eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 111: hz_cust_site_uses_all b,

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'
115: AND a.party_site_id = c.party_site_id

Line 3105: hz_cust_site_uses_all b,

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
3109: AND b.site_use_code = 'SHIP_TO'

Line 3122: hz_cust_site_uses_all b,

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
3126: AND b.site_use_code = 'BILL_TO'

Line 3142: hz_cust_site_uses_all b,

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
3146: AND b.site_use_code = 'BILL_TO'

Line 11086: hz_cust_site_uses_all b,

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'
11090: AND a.party_site_id = c.party_site_id

Line 15847: hz_cust_site_uses_all b,

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
15851: a.cust_acct_site_id = b.cust_acct_site_id

Line 15865: hz_cust_site_uses_all b,

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
15869: a.cust_acct_site_id = b.cust_acct_site_id

Line 15922: hz_cust_site_uses_all b,

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'
15926: AND a.party_site_id = c.party_site_id

Line 19534: -- ship_to_org_id from oe_order_lines_all is the site_use_id value from hz_cust_site_uses_all

19530: END IF;
19531:
19532: OPEN l_oeorderlines_csr(l_billingdtls_rec.isl_id);
19533: FETCH l_oeorderlines_csr INTO l_inv_item_id, l_inv_item_org_id, lx_ship_to_siteuseid;
19534: -- ship_to_org_id from oe_order_lines_all is the site_use_id value from hz_cust_site_uses_all
19535: -- which is the ship_to_site_use_id
19536: IF l_oeorderlines_csr%NOTFOUND THEN
19537: OKC_API.set_message( p_app_name => 'OKC',
19538: p_msg_name => G_INVALID_VALUE,