APPS.OM_TAX_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 6: site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%TYPE,

2: /* $Header: OEXUTAXB.pls 120.20.12010000.4 2008/11/13 08:40:06 amallik ship $ */
3: G_DEBUG_BYPASS_TAX CONSTANT VARCHAR2(1):=nvl(Fnd_Profile.value('OE_DBG_BYPASS'),'N');
4: -- structure for caching loc_ship_bill_info
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,

Line 7: acct_site_id HZ_CUST_SITE_USES_ALL.cust_acct_site_id%TYPE,

3: G_DEBUG_BYPASS_TAX CONSTANT VARCHAR2(1):=nvl(Fnd_Profile.value('OE_DBG_BYPASS'),'N');
4: -- structure for caching loc_ship_bill_info
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,

Line 67: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;

63: l_ship_location_id NUMBER(15);
64: l_bill_party_id NUMBER(15);
65: l_bill_party_site_id NUMBER(15);
66: l_bill_location_id NUMBER(15);
67: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;
68: l_ship_to_address_id NUMBER ;
69: l_ship_to_customer_id NUMBER ;
70: l_ship_to_postal_code VARCHAR2(60);
71: l_ship_to_customer_name VARCHAR2(360);

Line 119: cursor getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

115: l_invoice_number_profile VARCHAR2(30);
116: l_bill_from_location_id NUMBER;
117:
118:
119: cursor getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
120: SELECT /* MOAC_SQL_CHANGE */ s_ship.site_use_id,
121: s_ship.cust_acct_site_id,
122: acct_site_ship.cust_account_id,
123: loc_ship.postal_code,

Line 1718: FROM HZ_CUST_SITE_USES_ALL site_use ,

1714:
1715: IF (l_invoice_to_org_id IS NOT NULL) THEN
1716: SELECT acct_site.cust_account_id
1717: INTO l_bill_to_customer_id
1718: FROM HZ_CUST_SITE_USES_ALL site_use ,
1719: HZ_CUST_ACCT_SITES_ALL acct_site
1720: WHERE site_use.site_use_id = l_invoice_to_org_id
1721: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id;
1722: END IF;