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 11050: FROM hz_cust_acct_sites_all a,

11046: SELECT b.site_use_id,
11047: c.party_site_id,
11048: c.party_id,
11049: c.location_id
11050: FROM hz_cust_acct_sites_all a,
11051: hz_cust_site_uses_all b,
11052: hz_party_sites c
11053: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID
11054: AND b.site_use_code = 'SHIP_TO'

Line 15774: FROM hz_cust_acct_sites_all a,

15770: b.site_use_id,
15771: c.party_site_id,
15772: c.party_id,
15773: c.location_id
15774: FROM hz_cust_acct_sites_all a,
15775: hz_cust_site_uses_all b,
15776: hz_party_sites c,
15777: hz_parties d
15778: WHERE

Line 15792: FROM hz_cust_acct_sites_all a,

15788: b.site_use_id,
15789: c.party_site_id,
15790: c.party_id,
15791: c.location_id
15792: FROM hz_cust_acct_sites_all a,
15793: hz_cust_site_uses_all b,
15794: hz_party_sites c,
15795: hz_parties d
15796: WHERE

Line 15849: FROM hz_cust_acct_sites_all a,

15845:
15846: -- Cursor to get the ship_to_site_use_id corresponding to the install_location_id of the asset
15847: CURSOR l_get_shiptositeid(cp_cust_acct_id IN NUMBER, cp_inst_loc_id IN NUMBER,cp_loc_id IN NUMBER) IS
15848: SELECT b.site_use_id, c.party_site_id, c.party_id, c.location_id
15849: FROM hz_cust_acct_sites_all a,
15850: hz_cust_site_uses_all b,
15851: hz_party_sites c
15852: WHERE a.cust_acct_site_id = b.cust_acct_site_id
15853: AND b.site_use_code = 'SHIP_TO'