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.CSI_ASSET_PVT dependencies on HZ_PARTY_SITES

Line 124: SELECT decode(cii.location_type_code,'HZ_PARTY_SITES',

120: -- and these ID's are derived from the same Database sequence, the query has been simplified.
121: --
122: -- Following cursor will be used if p_location_id is not passed.
123: CURSOR csi_location_cur IS
124: SELECT decode(cii.location_type_code,'HZ_PARTY_SITES',
125: (select hzp.location_id
126: from hz_party_sites hzp
127: where hzp.party_site_id = cii.location_id),cii.location_id) cii_location_id
128: FROM csi_item_instances cii

Line 126: from hz_party_sites hzp

122: -- Following cursor will be used if p_location_id is not passed.
123: CURSOR csi_location_cur IS
124: SELECT decode(cii.location_type_code,'HZ_PARTY_SITES',
125: (select hzp.location_id
126: from hz_party_sites hzp
127: where hzp.party_site_id = cii.location_id),cii.location_id) cii_location_id
128: FROM csi_item_instances cii
129: WHERE cii.instance_id = px_instance_asset_rec.instance_id;
130: --