DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on HZ_PARTY_SITES

Line 14: party_site_id HZ_PARTY_SITES.party_site_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,
14: party_site_id HZ_PARTY_SITES.party_site_id%TYPE,
15: location_id HZ_LOCATIONS.location_id%TYPE);
16:
17: TYPE ship_bill_records IS TABLE OF loc_ship_bill_info_rec INDEX BY BINARY_INTEGER;
18: ship_bill_records_tab ship_bill_records;

Line 139: HZ_PARTY_SITES PARTY_SITE_SHIP,

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
143: WHERE s_ship.site_use_id = p_site_org_id