APPS.OM_TAX_UTIL dependencies on HZ_CUST_ACCT_SITES_ALL

Line 9: cust_acct_id HZ_CUST_ACCT_SITES_ALL.cust_account_id%TYPE,

5: -- structure for caching loc_ship_bill_info
6: TYPE loc_ship_bill_info_rec IS RECORD (
7: site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%TYPE,
8: acct_site_id HZ_CUST_SITE_USES_ALL.cust_acct_site_id%TYPE,
9: cust_acct_id HZ_CUST_ACCT_SITES_ALL.cust_account_id%TYPE,
10: postal_code HZ_LOCATIONS.postal_code%TYPE,
11: customer_name HZ_PARTIES.party_name%TYPE,
12: customer_number HZ_CUST_ACCOUNTS_ALL.account_number%TYPE,
13: party_id HZ_PARTIES.party_id%TYPE,

Line 138: HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP,

134: party.party_id,
135: party_site_ship.party_site_id,
136: loc_ship.location_id
137: FROM HZ_CUST_SITE_USES S_SHIP ,
138: HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP,
139: HZ_PARTY_SITES PARTY_SITE_SHIP,
140: HZ_LOCATIONS LOC_SHIP,
141: HZ_PARTIES PARTY,
142: HZ_CUST_ACCOUNTS_ALL CUST_ACCT

Line 2587: HZ_CUST_ACCT_SITES_ALL acct_site

2583: IF (l_invoice_to_org_id IS NOT NULL) THEN
2584: SELECT acct_site.cust_account_id
2585: INTO l_bill_to_customer_id
2586: FROM HZ_CUST_SITE_USES_ALL site_use ,
2587: HZ_CUST_ACCT_SITES_ALL acct_site
2588: WHERE site_use.site_use_id = l_invoice_to_org_id
2589: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id;
2590: END IF;
2591: