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_SPLIT_ASSET_PVT dependencies on HZ_PARTY_SITE_USES

Line 4759: FROM hz_party_site_uses

4755:
4756: --Cursor to get install site use id
4757: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS
4758: SELECT TO_CHAR(Party_site_use_id) party_site_use_id
4759: FROM hz_party_site_uses
4760: WHERE party_site_id = pty_site_id
4761: AND site_use_type = 'INSTALL_AT';
4762:
4763:

Line 4767: FROM hz_party_site_uses psu,

4763:
4764: --BUG# 3569441
4765: CURSOR inst_loc_csr (loc_id IN NUMBER) IS
4766: SELECT TO_CHAR(psu.party_site_use_id) party_site_use_id
4767: FROM hz_party_site_uses psu,
4768: hz_party_sites ps
4769: WHERE psu.party_site_id = ps.party_site_id
4770: AND psu.site_use_type = 'INSTALL_AT'
4771: AND ps.location_id = loc_id;

Line 5362: FROM hz_party_site_uses

5358:
5359: --Cursor to get install site use id
5360: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS
5361: SELECT TO_CHAR(Party_site_use_id) party_site_use_id
5362: FROM hz_party_site_uses
5363: WHERE party_site_id = pty_site_id
5364: AND site_use_type = 'INSTALL_AT';
5365:
5366: --BUG# 3569441

Line 5369: FROM hz_party_site_uses psu,

5365:
5366: --BUG# 3569441
5367: CURSOR inst_loc_csr (loc_id IN NUMBER) IS
5368: SELECT TO_CHAR(psu.party_site_use_id) party_site_use_id
5369: FROM hz_party_site_uses psu,
5370: hz_party_sites ps
5371: WHERE psu.party_site_id = ps.party_site_id
5372: AND psu.site_use_type = 'INSTALL_AT'
5373: AND ps.location_id = loc_id;