DBA Data[Home] [Help]

APPS.OE_CREDIT_EXPOSURE_PVT dependencies on RA_INTERFACE_LINES_ALL

Line 5228: , ra_interface_lines_all rl

5224: , hz_cust_accounts ca
5225: , hz_cust_site_uses_all su_l
5226: , hz_cust_acct_sites_all s_l
5227: , hz_cust_accounts ca_l
5228: , ra_interface_lines_all rl
5229: where h.header_id = l.header_id
5230: AND h.booked_flag = 'Y'
5231: AND rl.orig_system_bill_customer_id = ca.cust_account_id
5232: AND nvl(rl.interface_status, '~') <> 'P'

Line 6271: , ra_interface_lines_all rl

6267: , oe_order_headers_all h
6268: , hz_cust_site_uses_all su
6269: , hz_cust_acct_sites_all s
6270: , hz_cust_accounts ca
6271: , ra_interface_lines_all rl
6272: WHERE
6273: p.line_id IS NULL
6274: AND p.header_id = h.header_id
6275: AND h.order_category_code IN ('ORDER','MIXED')

Line 6435: , ra_interface_lines_all rl

6431: , oe_order_headers_all h
6432: , hz_cust_site_uses_all su
6433: , hz_cust_acct_sites_all s
6434: , hz_cust_accounts ca
6435: , ra_interface_lines_all rl
6436: WHERE
6437: p.line_id IS NULL
6438: AND p.header_id = h.header_id
6439: AND h.order_category_code ='RETURN'