APPS.OE_CREDIT_INTERFACE_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 155: FROM oe_price_adjustments p

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

Line 190: FROM oe_price_adjustments p

186: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL));
187:
188: CURSOR cust_reg_orders_freight2 (p_curr_code IN VARCHAR2 default null) IS
189: SELECT SUM( NVL( rl.amount, 0 ))
190: FROM oe_price_adjustments p
191: , oe_order_headers_all h
192: , ra_interface_lines_all rl
193: WHERE rl.orig_system_bill_customer_id = l_customer_id
194: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(p_site_use_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462

Line 293: FROM oe_price_adjustments p

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

Line 326: FROM oe_price_adjustments p

322: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL));
323:
324: CURSOR cust_glb_orders_freight2 (p_curr_code IN VARCHAR2 default null) IS
325: SELECT SUM( NVL( rl.amount, 0 ))
326: FROM oe_price_adjustments p
327: , oe_order_headers_all h
328: , ra_interface_lines_all rl
329: WHERE rl.orig_system_bill_customer_id = l_customer_id
330: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(p_site_use_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462