APPS.INV_TRANSACTION_FLOW_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 2423: , hz_cust_site_uses_all rsu

2419: WHERE acct_site.party_site_id = party_site.party_site_id
2420: AND loc.location_id = party_site.location_id
2421: AND loc.location_id = loc_assign.location_id
2422: AND NVL(acct_site.org_id, -99) = NVL(loc_assign.org_id, -99)) ra
2423: , hz_cust_site_uses_all rsu
2424: WHERE NVL(rsu.status, 'A') = 'A'
2425: AND rsu.site_use_code = 'BILL_TO'
2426: AND ra.address_id = rsu.cust_acct_site_id
2427: AND NVL(ra.status, 'A') = 'A'

Line 2484: , hz_cust_site_uses_all rsu

2480: WHERE acct_site.party_site_id = party_site.party_site_id
2481: AND loc.location_id = party_site.location_id
2482: AND loc.location_id = loc_assign.location_id
2483: AND NVL(acct_site.org_id, -99) = NVL(loc_assign.org_id, -99)) ra
2484: , hz_cust_site_uses_all rsu
2485: WHERE NVL(rsu.status, 'A') = 'A'
2486: AND rsu.site_use_code = 'BILL_TO'
2487: AND ra.address_id = rsu.cust_acct_site_id
2488: AND NVL(ra.status, 'A') = 'A'

Line 4738: , hz_cust_site_uses_all rsu

4734: , rc.customer_number
4735: , rc.customer_name
4736: INTO l_price_List_Id, l_location, l_customer_number, l_customer_name
4737: FROM mtl_intercompany_parameters mip
4738: , hz_cust_site_uses_all rsu
4739: , (SELECT cust_account_id customer_id
4740: , party.party_name customer_name
4741: , party.party_number customer_number
4742: , price_list_id