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_PRICE_ADJUSTMENTS

Line 165: FROM oe_price_adjustments p

161:
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

Line 202: FROM oe_price_adjustments p,oe_price_adjustments p1

198: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL))
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

Line 243: FROM oe_price_adjustments p

239:
240:
241: CURSOR cust_reg_orders_freight2 (p_curr_code IN VARCHAR2 default null,l_cust_acct_site_id IN NUMBER DEFAULT NULL) IS -- bug 8744491
242: SELECT SUM( NVL( rl.amount, 0 ))
243: FROM oe_price_adjustments p
244: , oe_order_headers_all h
245: , ra_interface_lines_all rl
246: WHERE rl.orig_system_bill_customer_id = l_customer_id
247: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491

Line 279: FROM oe_price_adjustments p,oe_price_adjustments p1

275: l.payment_type_code))
276: --TaxER Start
277: UNION ALL
278: 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))
279: FROM oe_price_adjustments p,oe_price_adjustments p1
280: , oe_order_headers_all h
281: , ra_interface_lines_all rl
282: WHERE rl.orig_system_bill_customer_id = l_customer_id
283: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491

Line 395: FROM oe_price_adjustments p

391:
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

Line 430: FROM oe_price_adjustments p,oe_price_adjustments p1

426: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL))
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

Line 469: FROM oe_price_adjustments p

465:
466:
467: CURSOR cust_glb_orders_freight2 (p_curr_code IN VARCHAR2 default null,l_cust_acct_site_id IN NUMBER DEFAULT NULL) IS -- bug 8744491
468: SELECT SUM( NVL( rl.amount, 0 ))
469: FROM oe_price_adjustments p
470: , oe_order_headers_all h
471: , ra_interface_lines_all rl
472: WHERE rl.orig_system_bill_customer_id = l_customer_id
473: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491

Line 505: FROM oe_price_adjustments p

501: l.payment_type_code))
502: --TaxER Start
503: UNION ALL
504: 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))
505: FROM oe_price_adjustments p
506: ,oe_price_adjustments p1
507: , oe_order_headers_all h
508: , ra_interface_lines_all rl
509: WHERE rl.orig_system_bill_customer_id = l_customer_id

Line 506: ,oe_price_adjustments p1

502: --TaxER Start
503: UNION ALL
504: 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))
505: FROM oe_price_adjustments p
506: ,oe_price_adjustments p1
507: , oe_order_headers_all h
508: , ra_interface_lines_all rl
509: WHERE rl.orig_system_bill_customer_id = l_customer_id
510: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(l_cust_acct_site_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462 bug 8744491