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 11051: hz_cust_site_uses_all b,

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

Line 15775: hz_cust_site_uses_all b,

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

Line 15793: hz_cust_site_uses_all b,

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

Line 15850: hz_cust_site_uses_all b,

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

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

19347: END IF;
19348:
19349: OPEN l_oeorderlines_csr(l_billingdtls_rec.isl_id);
19350: FETCH l_oeorderlines_csr INTO l_inv_item_id, l_inv_item_org_id, lx_ship_to_siteuseid;
19351: -- ship_to_org_id from oe_order_lines_all is the site_use_id value from hz_cust_site_uses_all
19352: -- which is the ship_to_site_use_id
19353: IF l_oeorderlines_csr%NOTFOUND THEN
19354: OKC_API.set_message( p_app_name => 'OKC',
19355: p_msg_name => G_INVALID_VALUE,