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_ALL

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