DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 80: FROM OE_PRICE_ADJUSTMENTS P

76: SELECT PRICE_ADJUSTMENT_ID,ROUND (
77: DECODE (P.CREDIT_OR_CHARGE_FLAG,'C',-P.OPERAND,P.OPERAND)
78: ,OE_ORDER_UTIL.G_Precision)
79: BULK COLLECT INTO l_charge_tbl
80: FROM OE_PRICE_ADJUSTMENTS P
81: WHERE P.HEADER_ID = p_header_id
82: AND P.LINE_ID IS NULL
83: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
84: AND P.APPLIED_FLAG = 'Y';

Line 95: FROM OE_PRICE_ADJUSTMENTS P,

91: DECODE (L.ORDERED_QUANTITY,0,0,P.OPERAND),
92: (L.ORDERED_QUANTITY* nvl(P.ADJUSTED_AMOUNT,0)))
93: ,OE_ORDER_UTIL.G_Precision)
94: BULK COLLECT INTO l_charge_tbl
95: FROM OE_PRICE_ADJUSTMENTS P,
96: OE_ORDER_LINES_ALL L
97: WHERE P.HEADER_ID = p_header_id
98: AND P.LINE_ID = p_line_id
99: AND P.LINE_ID = L.LINE_ID