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_CHARGE_PVT dependencies on OE_ORDER_LINES_ALL

Line 102: OE_ORDER_LINES_ALL L

98: L.ORDERED_QUANTITY* nvl(P.ADJUSTED_AMOUNT,0)))
99: ,OE_ORDER_UTIL.G_Precision),0))
100: INTO l_charge_amount
101: FROM OE_PRICE_ADJUSTMENTS P,
102: OE_ORDER_LINES_ALL L
103: WHERE P.HEADER_ID = p_header_id
104: AND P.LINE_ID = L.LINE_ID(+)
105: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
106: AND L.charge_periodicity_code(+) IS NULL -- added for recurring charge

Line 156: OE_ORDER_LINES_ALL L

152: ,OE_ORDER_UTIL.G_Precision)
153: )
154: INTO l_charge_amount
155: FROM OE_PRICE_ADJUSTMENTS P,
156: OE_ORDER_LINES_ALL L
157: WHERE P.HEADER_ID = p_header_id
158: AND P.LINE_ID = p_line_id
159: AND P.LINE_ID = L.LINE_ID
160: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'

Line 1347: OE_ORDER_LINES_ALL L

1343: ,OE_ORDER_UTIL.G_Precision)
1344: )
1345: INTO l_charge_amount
1346: FROM OE_PRICE_ADJUSTMENTS P,
1347: OE_ORDER_LINES_ALL L
1348: WHERE P.HEADER_ID = p_header_id
1349: AND P.LINE_ID = L.LINE_ID(+)
1350: AND nvl(L.CHARGE_PERIODICITY_CODE,'ONE') = p_charge_periodicity_code
1351: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'