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 RA_INTERFACE_LINES_ALL

Line 28: -- Comments : Return the overall exposure amount in RA_INTERFACE_LINES_ALL table

24: G_DEBUG_FLAG VARCHAR2(1) := NVL(oe_credit_check_util.check_debug_flag , 'N' ) ;
25:
26: --===============================================================================
27: -- PROCEDURE : Get_exposure_amount
28: -- Comments : Return the overall exposure amount in RA_INTERFACE_LINES_ALL table
29: --===============================================================================
30: PROCEDURE Get_exposure_amount
31: ( p_header_id IN NUMBER
32: , p_customer_id IN NUMBER

Line 95: , ra_interface_lines_all rl

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
99: AND h.org_id = l.org_id

Line 128: , ra_interface_lines_all rl

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
132: AND h.org_id = l.org_id

Line 158: , ra_interface_lines_all rl

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
162: AND NVL( l.invoiced_quantity, 0 ) <> 0

Line 192: , ra_interface_lines_all rl

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
196: AND p.header_id = h.header_id

Line 235: , ra_interface_lines_all rl

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
239: AND NVL( l.invoiced_quantity, 0 ) <> 0

Line 267: , ra_interface_lines_all rl

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
271: AND NVL( l.invoiced_quantity, 0 ) <> 0

Line 296: , ra_interface_lines_all rl

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
300: AND NVL( l.invoiced_quantity, 0 ) <> 0

Line 328: , ra_interface_lines_all rl

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
332: AND p.header_id = h.header_id