DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PUB dependencies on HZ_LOCATIONS

Line 2418: FROM hz_party_sites party_site, hz_loc_assignments loc_assign, hz_locations loc, hz_cust_acct_sites_all acct_site

2414: FROM (SELECT loc_id address_id
2415: , acct_site.status
2416: , cust_account_id customer_id
2417: , acct_site.org_id
2418: FROM hz_party_sites party_site, hz_loc_assignments loc_assign, hz_locations loc, hz_cust_acct_sites_all acct_site
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

Line 2479: FROM hz_party_sites party_site, hz_loc_assignments loc_assign, hz_locations loc, hz_cust_acct_sites_all acct_site

2475: FROM (SELECT loc_id address_id
2476: , acct_site.status
2477: , cust_account_id customer_id
2478: , acct_site.org_id
2479: FROM hz_party_sites party_site, hz_loc_assignments loc_assign, hz_locations loc, hz_cust_acct_sites_all acct_site
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