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_ASSET_SUBSIDY_PVT dependencies on HZ_PARTY_SITES

Line 1242: hz_party_sites hzps,

1238: cursor l_terr_csr (p_subsidy_id in number,
1239: p_asset_cle_id in number) is
1240: select 'Y'
1241: from hz_locations loc,
1242: hz_party_sites hzps,
1243: hz_party_site_uses hzpsu,
1244: okl_txl_itm_insts iti,
1245: --csi_item_instances csii,
1246: --okc_k_items cim_ib,

Line 1840: hz_party_sites hzps,

1836: cursor l_terr_csr (p_subsidy_id in number,
1837: p_install_site_use_id in number) is
1838: select 'Y'
1839: from hz_locations loc,
1840: hz_party_sites hzps,
1841: hz_party_site_uses hzpsu,
1842: okl_subsidy_criteria suc
1843: Where hzpsu.party_site_use_id = p_install_site_use_id
1844: And hzps.party_site_id = hzpsu.party_site_id

Line 2358: hz_party_sites hzps,

2354: /* cursor l_terr_csr (p_subsidy_id in number,
2355: p_install_site_use_id in number) is
2356: select 'Y'
2357: from hz_locations loc,
2358: hz_party_sites hzps,
2359: hz_party_site_uses hzpsu,
2360: okl_subsidy_criteria suc
2361: Where hzpsu.party_site_use_id = p_install_site_use_id
2362: And hzps.party_site_id = hzpsu.party_site_id