DBA Data[Home] [Help]

APPS.OE_HEADER_ADJ_UTIL dependencies on OE_PRICE_ADJUSTMENTS_V

Line 4402: FROM oe_price_adjustments_v opa

4398: 'AMT',opa.operand,
4399: 'NEWPRICE',ool.unit_list_price-opa.operand))
4400: unit_discount_amount
4401: --Bug 3340636 Ends
4402: FROM oe_price_adjustments_v opa
4403: , oe_order_lines_all ool
4404: WHERE opa.HEADER_ID = p_header_id
4405: and opa.line_id is null
4406: and ool.line_id = p_line_id

Line 4421: FROM oe_price_adjustments_v opa

4417: ,opa.adjustment_type_code
4418: ,opa.operand
4419: ,opa.arithmetic_operator
4420: ,opa.adjusted_amount*(-1) unit_discount_amount
4421: FROM oe_price_adjustments_v opa
4422: , oe_order_lines_all ool
4423: WHERE opa.line_id =p_line_id
4424: and ool.line_id = p_line_id
4425: and ool.header_id = p_header_id