DBA Data[Home] [Help]

APPS.OE_HEADER_ADJ_UTIL dependencies on OE_PRICE_ADJUSTMENTS_V

Line 4461: FROM oe_price_adjustments_v opa

4457: 'AMT',opa.operand,
4458: 'NEWPRICE',ool.unit_list_price-opa.operand))
4459: unit_discount_amount
4460: --Bug 3340636 Ends
4461: FROM oe_price_adjustments_v opa
4462: , oe_order_lines_all ool
4463: WHERE opa.HEADER_ID = p_header_id
4464: and opa.line_id is null
4465: and ool.line_id = p_line_id

Line 4480: FROM oe_price_adjustments_v opa

4476: ,opa.adjustment_type_code
4477: ,opa.operand
4478: ,opa.arithmetic_operator
4479: ,Nvl(opa.adjusted_amount,0)*(-1) unit_discount_amount --added nvl for bug 13605684
4480: FROM oe_price_adjustments_v opa
4481: , oe_order_lines_all ool
4482: WHERE opa.line_id =p_line_id
4483: and ool.line_id = p_line_id
4484: and ool.header_id = p_header_id