6/6/2012 · FROM oe_ order_lines_all where header_id=ool.header_id AND line_id=ool.line_id and org_id=ool.org_id)line_total, SUM(NVL (ool.tax_value, 0)) tax_amount,(SELECT NVL(SUM(NVL(opa.operand,0)),0) FROM oe_ price _adjustments opa WHERE opa.header_id = ooh.header_id AND opa.line_id=ool.line_id AND opa.applied_flag = ‘Y’, 1/13/2015 · oe_ price _adjustments pa, oe_ order_lines_all l, oe_order_headers_all h WHERE h.order_number = 14463 AND h.header_id = l.header_id AND h.org_id = l.org_id AND h.header_id = pa.header_id AND l.line_id = pa.line_id(+) AND pa.list_header_id = lh.list_header_id AND ( PA.LIST_LINE_TYPE_CODE = ‘DIS’ …
OE_ORDER_LINES_ALL. SALES CREDITS OE_SALES_CREDITS. PRICE ADJUSTMENTS OE_PRICE_ADJUSTMENTS This entity stores Order and Line price adjustments information. It stores the benefits offered at header, line or group of lines. Benefits can be discounts on other items, item upgrade, terms substitution, coupons, discounts, surcharges etc.
9/20/2014 · FROM oe_order_lines_all oeol, oe_price_adjustments oepj WHERE oeol.line_id = oepj.line_id AND oeol.attribute7 IS NOT Null AND Nvl(oeol.cancelled_flag, ‘N’) = ‘N’ AND oeol.return_attribute5 IS Null AND oeol.open_flag = ‘Y’ AND Nvl(Upper(oeol.attribute10), ‘Y’) = ‘Y’ AND oeol.booked_flag = ‘Y’ AND oepj.attribute1 IS Null, 2/6/2013 · oe_order_lines_all Lines for particular records oe_price_adjustments When discount gets applied oe_order_price_attribs If line has price attributes then populated oe_order_holds_all If any hold applied for order like credit check etc. Booked oe_order_headers_all Booked_flag=Y Order booked. wsh_delivery_details Released_status Ready to release, 4/29/2015 · API to Create & Update Price Adjustment and Order Lines. Important Tables: select header_id from oe_order_headers_all select line_id from oe_order_lines_all select list_header_id from qp_list_headers_all select list_line_id from qp_list_lines CREATE OR REPLACE PROCEDURE apps.xxapply_discount (p_header_id number) IS.
9/13/2019 · oe_ order_lines_all OOLA, OE_ PRICE _ADJUSTMENTS OPA, ZX_RATES_B ZRB where 1=1 AND OOHA.header_id=OOLA.header_id AND OOLA.LINE_ID=OPA.LINE_ID AND OPA.TAX_RATE_ID =ZRB.TAX_RATE_ID AND OOHA.ORDER_NUMBER = (:Order Number) –AND OOLA.LINE_ID=’35020694? …
2/13/2021 · oe_ order_lines_all Lines for particular records oe_ price _adjustments When discount gets applied oe_order_price_attribs If line has price attributes then populated oe_order_holds_all If any hold applied for order like credit check etc. Booked oe_order_headers_all Booked_flag=Y Order booked. wsh_delivery_details Released_status Ready to release, 9/1/2014 · OE_ PRICE _ADJUSTMENTS – when discount gets applied. OE_ORDER_PRICE_ATTRIBS – if line has price attributes. … When the Order is Booked, the Flow_Status_Code in OE_ORDER_HEADERS_ALL will be ‘Booked’ and the Flow_Status_Code in OE_ ORDER_LINES_ALL will be ‘Awaiting Shipping’.
