APPS.OE_CREDIT_INTERFACE_UTIL dependencies on OE_ORDER_LINES_ALL

Line 233: FROM oe_order_lines_all l

229: ( NVL( rl.amount, 0 ) )
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

Line 265: FROM oe_order_lines_all l

261: ( DECODE( SIGN (NVL( rl.quantity_ordered, 0 )), -1, (+1), (-1) ) * NVL( rl.amount, 0 ) )
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

Line 294: , oe_order_lines_all l

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
298: AND rl.ORIG_SYSTEM_BILL_ADDRESS_ID = nvl(p_site_use_id,ORIG_SYSTEM_BILL_ADDRESS_ID) --6896462