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_CREDIT_INTERFACE_UTIL dependencies on OE_ORDER_LINES

Line 93: FROM oe_order_lines l

89: ( NVL( rl.amount, 0 ) )
90: + DECODE( rl.interface_line_attribute11, '0', DECODE(l_include_tax_flag, 'Y',
91: NVL(l.tax_value,0), 0 ), 0 )
92: )
93: FROM oe_order_lines l
94: , oe_order_headers_all h
95: , ra_interface_lines_all rl
96: WHERE rl.orig_system_bill_customer_id = l_customer_id
97: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(p_site_use_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462

Line 126: FROM oe_order_lines l

122: ( DECODE( SIGN (NVL( rl.quantity_ordered, 0 )), -1, (+1), (-1) ) * NVL( rl.amount, 0 ) )
123: + DECODE( rl.interface_line_attribute11, '0', DECODE(l_include_tax_flag, 'Y',
124: NVL(DECODE(l.line_category_code,'RETURN',(-1)*l.tax_value,l.tax_value),0),0), 0 )
125: )
126: FROM oe_order_lines l
127: , oe_order_headers_all h
128: , ra_interface_lines_all rl
129: WHERE rl.orig_system_bill_customer_id = l_customer_id
130: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(p_site_use_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462

Line 156: , oe_order_lines l

152: ---CUSTOMER/SITE FREIGHT ORDERS
153: CURSOR cust_reg_orders_freight1 (p_curr_code IN VARCHAR2 default null) IS
154: SELECT SUM( NVL( rl.amount, 0 ))
155: FROM oe_price_adjustments p
156: , oe_order_lines l
157: , oe_order_headers_all h
158: , ra_interface_lines_all rl
159: WHERE rl.orig_system_bill_customer_id = l_customer_id
160: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(p_site_use_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462

Line 211: oe_order_lines l

207: AND rl.interface_line_attribute6 = p.price_adjustment_id
208: AND EXISTS
209: (SELECT NULL
210: FROM oe_payment_types_all pt,
211: oe_order_lines l
212: WHERE pt.credit_check_flag = 'Y'
213: AND l.header_id = h.header_id
214: AND l.org_id = pt.org_id
215: AND NVL(pt.org_id, -99) = l_org_id

Line 233: FROM oe_order_lines_all l

229: ( NVL( rl.amount, 0 ) )
230: + DECODE( rl.interface_line_attribute11, '0', DECODE(l_include_tax_flag, 'Y',
231: NVL(l.tax_value,0), 0 ), 0 )
232: )
233: FROM oe_order_lines_all l
234: , oe_order_headers_all h
235: , ra_interface_lines_all rl
236: WHERE rl.orig_system_bill_customer_id = l_customer_id
237: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(p_site_use_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462

Line 265: FROM oe_order_lines_all l

261: ( DECODE( SIGN (NVL( rl.quantity_ordered, 0 )), -1, (+1), (-1) ) * NVL( rl.amount, 0 ) )
262: + DECODE( rl.interface_line_attribute11, '0', DECODE(l_include_tax_flag, 'Y',
263: NVL(DECODE(l.line_category_code,'RETURN',(-1)*l.tax_value,l.tax_value),0),0), 0 )
264: )
265: FROM oe_order_lines_all l
266: , oe_order_headers_all h
267: , ra_interface_lines_all rl
268: WHERE rl.orig_system_bill_customer_id = l_customer_id
269: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(p_site_use_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462

Line 294: , oe_order_lines_all l

290: ---GLOBAL FREIGHT ORDERS
291: CURSOR cust_glb_orders_freight1 (p_curr_code IN VARCHAR2 default null) IS
292: SELECT SUM( NVL( rl.amount, 0 ))
293: FROM oe_price_adjustments p
294: , oe_order_lines_all l
295: , oe_order_headers_all h
296: , ra_interface_lines_all rl
297: WHERE rl.orig_system_bill_customer_id = l_customer_id
298: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(p_site_use_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462

Line 347: oe_order_lines l

343: AND rl.interface_line_attribute6 = p.price_adjustment_id
344: AND EXISTS
345: (SELECT NULL
346: FROM oe_payment_types_all pt,
347: oe_order_lines l
348: WHERE pt.credit_check_flag = 'Y'
349: AND l.header_id = h.header_id
350: AND l.org_id = pt.org_id
351: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99)