eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_PRICE_ADJUSTMENTS

Line 7490: FROM OE_PRICE_ADJUSTMENTS P,

7486: )
7487: ,OE_ORDER_UTIL.G_Precision ) --8241416
7488: )
7489: INTO l_charge_amount
7490: FROM OE_PRICE_ADJUSTMENTS P,
7491: OE_ORDER_LINES_ALL L
7492: WHERE P.LINE_ID = p_line_id
7493: AND P.LINE_ID = L.LINE_ID
7494: AND NVL(L.SERVICE_BILL_OPTION_CODE,'FBOM') = 'FBOM' -- sol_ord_er #16014165

Line 7759: FROM OE_PRICE_ADJUSTMENTS P,

7755: (L.ORDERED_QUANTITY* nvl(P.ADJUSTED_AMOUNT,0)))
7756: )
7757: )
7758: INTO l_charge_amount
7759: FROM OE_PRICE_ADJUSTMENTS P,
7760: OE_ORDER_LINES_ALL L
7761: WHERE P.LINE_ID = p_line_id
7762: AND P.LINE_ID = L.LINE_ID
7763: AND NVL(L.SERVICE_BILL_OPTION_CODE,'FBOM') = 'FBOM' -- sol_ord_er #16014165

Line 7979: FROM OE_PRICE_ADJUSTMENTS P

7975: SELECT SUM(
7976: ROUND(DECODE(P.CREDIT_OR_CHARGE_FLAG,'C',(-1) * P.OPERAND,P.OPERAND),OE_ORDER_UTIL.G_Precision)
7977: )
7978: INTO l_chgs_wo_line_id
7979: FROM OE_PRICE_ADJUSTMENTS P
7980: WHERE P.HEADER_ID = p_header_id
7981: AND P.LINE_ID IS NULL
7982: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
7983: AND P.APPLIED_FLAG = 'Y'

Line 7997: FROM OE_PRICE_ADJUSTMENTS P,

7993: (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT))
7994: ),OE_ORDER_UTIL.G_Precision)
7995: )
7996: INTO l_chgs_w_line_id
7997: FROM OE_PRICE_ADJUSTMENTS P,
7998: OE_ORDER_LINES_ALL L
7999: WHERE P.HEADER_ID = p_header_id
8000: AND P.LINE_ID = L.LINE_ID
8001: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'