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 97: FROM oe_order_lines l

93: ( NVL( rl.amount, 0 ) )
94: + DECODE( rl.interface_line_attribute11, '0', DECODE(l_include_tax_flag, 'Y',
95: NVL(NVL(l.tax_line_value,l.tax_value),0), 0 ), 0 ) --TaxER
96: )
97: FROM oe_order_lines l
98: , oe_order_headers_all h
99: , ra_interface_lines_all rl
100: WHERE rl.orig_system_bill_customer_id = l_customer_id
101: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491

Line 133: FROM oe_order_lines l

129: ( DECODE( SIGN (NVL( rl.quantity_ordered, 0 )), -1, (+1), (-1) ) * NVL( rl.amount, 0 ) )
130: + DECODE( rl.interface_line_attribute11, '0', DECODE(l_include_tax_flag, 'Y',
131: NVL(DECODE(l.line_category_code,'RETURN',(-1)*NVL(l.tax_line_value,l.tax_value),NVL(l.tax_line_value,l.tax_value)),0),0), 0 ) --TaxER
132: )
133: FROM oe_order_lines l
134: , oe_order_headers_all h
135: , ra_interface_lines_all rl
136: WHERE rl.orig_system_bill_customer_id = l_customer_id
137: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491

Line 166: , oe_order_lines l

162: ---CUSTOMER/SITE FREIGHT ORDERS
163: CURSOR cust_reg_orders_freight1 (p_curr_code IN VARCHAR2 default null,l_cust_acct_site_id IN NUMBER DEFAULT NULL) IS -- bug 8744491
164: SELECT SUM( NVL( rl.amount, 0 ))
165: FROM oe_price_adjustments p
166: , oe_order_lines l
167: , oe_order_headers_all h
168: , ra_interface_lines_all rl
169: WHERE rl.orig_system_bill_customer_id = l_customer_id
170: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491

Line 203: , oe_order_lines l

199: --TaxER Start
200: UNION ALL
201: SELECT SUM(NVL(DECODE(p_credit_check_rule_rec.include_tax_flag,'Y',DECODE(p1.list_line_type_code,'TAX',p1.adjusted_amount,0),0),0))
202: FROM oe_price_adjustments p,oe_price_adjustments p1
203: , oe_order_lines l
204: , oe_order_headers_all h
205: , ra_interface_lines_all rl
206: WHERE rl.orig_system_bill_customer_id = l_customer_id
207: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491

Line 266: oe_order_lines l

262: AND TO_NUMBER(DECODE(RTRIM(TRANSLATE(rl.interface_line_attribute6,'0123456789','0'),'0'), NULL, rl.interface_line_attribute6,-99999)) = p.price_adjustment_id --bug 11662722
263: AND EXISTS
264: (SELECT NULL
265: FROM oe_payment_types_all pt,
266: oe_order_lines l
267: WHERE pt.credit_check_flag = 'Y'
268: AND l.header_id = h.header_id
269: AND l.org_id = pt.org_id
270: AND NVL(pt.org_id, -99) = l_org_id

Line 304: oe_order_lines l

300: AND TO_NUMBER(DECODE(RTRIM(TRANSLATE(rl.interface_line_attribute6,'0123456789','0'),'0'), NULL, rl.interface_line_attribute6,-99999)) = p.price_adjustment_id --bug 11662722
301: AND EXISTS
302: (SELECT NULL
303: FROM oe_payment_types_all pt,
304: oe_order_lines l
305: WHERE pt.credit_check_flag = 'Y'
306: AND l.header_id = h.header_id
307: AND l.org_id = pt.org_id
308: AND NVL(pt.org_id, -99) = l_org_id

Line 328: FROM oe_order_lines_all l

324: ( NVL( rl.amount, 0 ) )
325: + DECODE( rl.interface_line_attribute11, '0', DECODE(l_include_tax_flag, 'Y',
326: NVL(NVL(l.tax_line_value,l.tax_value),0), 0 ), 0 ) --TaxER
327: )
328: FROM oe_order_lines_all l
329: , oe_order_headers_all h
330: , ra_interface_lines_all rl
331: WHERE rl.orig_system_bill_customer_id = l_customer_id
332: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491

Line 363: FROM oe_order_lines_all l

359: ( DECODE( SIGN (NVL( rl.quantity_ordered, 0 )), -1, (+1), (-1) ) * NVL( rl.amount, 0 ) )
360: + DECODE( rl.interface_line_attribute11, '0', DECODE(l_include_tax_flag, 'Y',
361: NVL(DECODE(l.line_category_code,'RETURN',(-1)*NVL(l.tax_line_value,l.tax_value),NVL(l.tax_line_value,l.tax_value)),0),0), 0 ) --TaxER
362: )
363: FROM oe_order_lines_all l
364: , oe_order_headers_all h
365: , ra_interface_lines_all rl
366: WHERE rl.orig_system_bill_customer_id = l_customer_id
367: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491

Line 396: , oe_order_lines_all l

392: ---GLOBAL FREIGHT ORDERS
393: CURSOR cust_glb_orders_freight1 (p_curr_code IN VARCHAR2 default null,l_cust_acct_site_id IN NUMBER DEFAULT NULL) IS -- bug 8744491
394: SELECT SUM( NVL( rl.amount, 0 ))
395: FROM oe_price_adjustments p
396: , oe_order_lines_all l
397: , oe_order_headers_all h
398: , ra_interface_lines_all rl
399: WHERE rl.orig_system_bill_customer_id = l_customer_id
400: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491

Line 431: , oe_order_lines_all l

427: --TaxER Start
428: UNION ALL
429: SELECT SUM(NVL(DECODE(p_credit_check_rule_rec.include_tax_flag,'Y',DECODE(p1.list_line_type_code,'TAX',p1.adjusted_amount,0),0),0))
430: FROM oe_price_adjustments p,oe_price_adjustments p1
431: , oe_order_lines_all l
432: , oe_order_headers_all h
433: , ra_interface_lines_all rl
434: WHERE rl.orig_system_bill_customer_id = l_customer_id
435: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491

Line 492: oe_order_lines l

488: AND TO_NUMBER(DECODE(RTRIM(TRANSLATE(rl.interface_line_attribute6,'0123456789','0'),'0'), NULL, rl.interface_line_attribute6,-99999)) = p.price_adjustment_id --bug 11662722
489: AND EXISTS
490: (SELECT NULL
491: FROM oe_payment_types_all pt,
492: oe_order_lines l
493: WHERE pt.credit_check_flag = 'Y'
494: AND l.header_id = h.header_id
495: AND l.org_id = pt.org_id
496: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99)

Line 531: oe_order_lines l

527: AND TO_NUMBER(DECODE(RTRIM(TRANSLATE(rl.interface_line_attribute6,'0123456789','0'),'0'), NULL, rl.interface_line_attribute6,-99999)) = p.price_adjustment_id --bug 11662722
528: AND EXISTS
529: (SELECT NULL
530: FROM oe_payment_types_all pt,
531: oe_order_lines l
532: WHERE pt.credit_check_flag = 'Y'
533: AND l.header_id = h.header_id
534: AND l.org_id = pt.org_id
535: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99)