DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on HZ_LOCATIONS

Line 9: postal_code HZ_LOCATIONS.postal_code%TYPE,

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

Line 14: location_id HZ_LOCATIONS.location_id%TYPE);

10: customer_name HZ_PARTIES.party_name%TYPE,
11: customer_number HZ_CUST_ACCOUNTS_ALL.account_number%TYPE,
12: party_id HZ_PARTIES.party_id%TYPE,
13: party_site_id HZ_PARTY_SITES.party_site_id%TYPE,
14: location_id HZ_LOCATIONS.location_id%TYPE);
15:
16: TYPE ship_bill_records IS TABLE OF loc_ship_bill_info_rec INDEX BY BINARY_INTEGER;
17: ship_bill_records_tab ship_bill_records;
18: pr_index number;

Line 133: HZ_LOCATIONS LOC_SHIP,

129: FROM
130: HZ_CUST_SITE_USES S_SHIP ,
131: HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP,
132: HZ_PARTY_SITES PARTY_SITE_SHIP,
133: HZ_LOCATIONS LOC_SHIP,
134: HZ_PARTIES PARTY,
135: HZ_CUST_ACCOUNTS_ALL CUST_ACCT
136: WHERE s_ship.site_use_id = p_site_org_id
137: AND s_ship.cust_acct_site_id = acct_site_ship.cust_acct_site_id