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 4569: , hz_cust_site_uses_all rsu

4565: , rc.customer_number
4566: , rc.customer_name
4567: INTO l_price_List_Id, l_location, l_customer_number, l_customer_name
4568: FROM mtl_intercompany_parameters mip
4569: , hz_cust_site_uses_all rsu
4570: , (SELECT cust_account_id customer_id
4571: , party.party_name customer_name
4572: , party.party_number customer_number
4573: , price_list_id