APPS.OE_CREDIT_INTERFACE_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 94: , oe_order_headers_all h

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
98: AND h.header_id = l.header_id

Line 127: , oe_order_headers_all h

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
131: AND h.header_id = l.header_id

Line 157: , oe_order_headers_all h

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
161: AND p.line_id = l.line_id

Line 191: , oe_order_headers_all h

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
195: AND p.line_id IS NULL

Line 234: , oe_order_headers_all h

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
238: AND h.header_id = l.header_id

Line 266: , oe_order_headers_all h

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
270: AND h.header_id = l.header_id

Line 295: , oe_order_headers_all h

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
299: AND p.line_id = l.line_id

Line 327: , oe_order_headers_all h

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
331: AND p.line_id IS NULL