APPS.OM_TAX_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 7: site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%TYPE,

3: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT;
4: G_DEBUG_BYPASS_TAX CONSTANT VARCHAR2(1):=nvl(Fnd_Profile.value('OE_DBG_BYPASS'),'N');
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,

Line 8: acct_site_id HZ_CUST_SITE_USES_ALL.cust_acct_site_id%TYPE,

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

Line 124: CURSOR getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type)

120: IS
121: TABLE OF loc_ship_bill_info_rec INDEX BY BINARY_INTEGER;
122: ship_bill_records_tab ship_bill_records;
123: pr_index NUMBER;
124: CURSOR getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type)
125: IS
126: SELECT
127: /* MOAC_SQL_CHANGE */
128: s_ship.site_use_id,

Line 197: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;

193: l_commitment_id oe_order_lines.commitment_id%type;
194: l_cust_trx_type_id ra_cust_trx_types_all.cust_Trx_type_id%type;
195: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
196: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
197: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;
198: l_ship_to_address_id NUMBER ;
199: l_ship_to_customer_id NUMBER ;
200: l_ship_to_postal_code VARCHAR2(60);
201: l_ship_to_customer_name VARCHAR2(360);

Line 2586: FROM HZ_CUST_SITE_USES_ALL site_use ,

2582:
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;