APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 110: FROM hz_cust_acct_sites_all a,

106: --Cursor to get the ship_to_site_use_id corresponding to the install_location_id of the asset
107: CURSOR l_get_shiptositeid(cp_cust_acct_id IN NUMBER, cp_inst_loc_id IN NUMBER,cp_loc_id IN NUMBER) IS
108: SELECT /*a.CUST_ACCT_SITE_ID */
109: b.site_use_id
110: FROM hz_cust_acct_sites_all a,
111: hz_cust_site_uses_all b,
112: hz_party_sites c
113: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID
114: AND b.site_use_code = 'SHIP_TO'

Line 3104: FROM hz_cust_acct_sites_all a,

3100: b.site_use_id,
3101: c.party_site_id,
3102: c.party_id,
3103: c.location_id
3104: FROM hz_cust_acct_sites_all a,
3105: hz_cust_site_uses_all b,
3106: hz_party_sites c
3107: WHERE
3108: a.cust_acct_site_id = b.cust_acct_site_id

Line 3121: FROM hz_cust_acct_sites_all a,

3117: c.party_site_id,
3118: c.party_id,
3119: c.location_id,
3120: b.site_use_id
3121: FROM hz_cust_acct_sites_all a,
3122: hz_cust_site_uses_all b,
3123: hz_party_sites c
3124: WHERE
3125: a.cust_acct_site_id = b.cust_acct_site_id

Line 3141: FROM hz_cust_acct_sites_all a,

3137: c.party_site_id,
3138: c.party_id,
3139: c.location_id,
3140: b.site_use_id
3141: FROM hz_cust_acct_sites_all a,
3142: hz_cust_site_uses_all b,
3143: hz_party_sites c
3144: WHERE
3145: a.cust_acct_site_id = b.cust_acct_site_id

Line 11085: FROM hz_cust_acct_sites_all a,

11081: SELECT b.site_use_id,
11082: c.party_site_id,
11083: c.party_id,
11084: c.location_id
11085: FROM hz_cust_acct_sites_all a,
11086: hz_cust_site_uses_all b,
11087: hz_party_sites c
11088: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID
11089: AND b.site_use_code = 'SHIP_TO'

Line 15846: FROM hz_cust_acct_sites_all a,

15842: b.site_use_id,
15843: c.party_site_id,
15844: c.party_id,
15845: c.location_id
15846: FROM hz_cust_acct_sites_all a,
15847: hz_cust_site_uses_all b,
15848: hz_party_sites c,
15849: hz_parties d
15850: WHERE

Line 15864: FROM hz_cust_acct_sites_all a,

15860: b.site_use_id,
15861: c.party_site_id,
15862: c.party_id,
15863: c.location_id
15864: FROM hz_cust_acct_sites_all a,
15865: hz_cust_site_uses_all b,
15866: hz_party_sites c,
15867: hz_parties d
15868: WHERE

Line 15921: FROM hz_cust_acct_sites_all a,

15917:
15918: -- Cursor to get the ship_to_site_use_id corresponding to the install_location_id of the asset
15919: CURSOR l_get_shiptositeid(cp_cust_acct_id IN NUMBER, cp_inst_loc_id IN NUMBER,cp_loc_id IN NUMBER) IS
15920: SELECT b.site_use_id, c.party_site_id, c.party_id, c.location_id
15921: FROM hz_cust_acct_sites_all a,
15922: hz_cust_site_uses_all b,
15923: hz_party_sites c
15924: WHERE a.cust_acct_site_id = b.cust_acct_site_id
15925: AND b.site_use_code = 'SHIP_TO'