APPS.OE_CREDIT_EXPOSURE_PVT dependencies on RA_INTERFACE_LINES_ALL

Line 5865: , ra_interface_lines_all rl

5861: , hz_cust_accounts ca
5862: , hz_cust_site_uses_all su_l
5863: , hz_cust_acct_sites_all s_l
5864: , hz_cust_accounts ca_l
5865: , ra_interface_lines_all rl
5866: where h.header_id = l.header_id
5867: AND h.booked_flag = 'Y'
5868: AND rl.orig_system_bill_customer_id = ca.cust_account_id
5869: AND nvl(rl.interface_status, '~') <> 'P'

Line 7275: , ra_interface_lines_all rl

7271: , oe_order_headers_all h
7272: , hz_cust_site_uses_all su
7273: , hz_cust_acct_sites_all s
7274: , hz_cust_accounts ca
7275: , ra_interface_lines_all rl
7276: WHERE
7277: p.line_id IS NULL
7278: AND p.header_id = h.header_id
7279: AND h.order_category_code IN ('ORDER','MIXED')

Line 7432: , ra_interface_lines_all rl

7428: , oe_order_headers_all h
7429: , hz_cust_site_uses_all su
7430: , hz_cust_acct_sites_all s
7431: , hz_cust_accounts ca
7432: , ra_interface_lines_all rl
7433: WHERE
7434: p.line_id IS NULL
7435: AND p.header_id = h.header_id
7436: AND h.order_category_code IN ('ORDER','MIXED')

Line 7602: , ra_interface_lines_all rl

7598: , oe_order_headers_all h
7599: , hz_cust_site_uses_all su
7600: , hz_cust_acct_sites_all s
7601: , hz_cust_accounts ca
7602: , ra_interface_lines_all rl
7603: WHERE
7604: p.line_id IS NULL
7605: AND p.header_id = h.header_id
7606: AND h.order_category_code ='RETURN'

Line 7755: , ra_interface_lines_all rl

7751: , oe_order_headers_all h
7752: , hz_cust_site_uses_all su
7753: , hz_cust_acct_sites_all s
7754: , hz_cust_accounts ca
7755: , ra_interface_lines_all rl
7756: WHERE
7757: p.line_id IS NULL
7758: AND p.header_id = h.header_id
7759: AND h.order_category_code ='RETURN'