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: --

Line 2896: -- instance is passed as HZ_PARTY_SITES, location ID should be fetched from HZ_PARTY_SITES table

2892:
2893: /*-- Getting instance location setup with Asset location --*/
2894: IF l_location_id <> px_instance_sync_tbl( c_inst_rec ).location_id THEN
2895: -- Added for bug 13831286, From Open interface, If the location type code of the
2896: -- instance is passed as HZ_PARTY_SITES, location ID should be fetched from HZ_PARTY_SITES table
2897: IF (l_csi_debug_level > 0) THEN
2898: debug( 'px_instance_sync_tbl( c_inst_rec ).location_type_code : '||px_instance_sync_tbl( c_inst_rec ).location_type_code);
2899: END IF;
2900: IF px_instance_sync_tbl( c_inst_rec ).location_type_code = 'HZ_PARTY_SITES' THEN

Line 2900: IF px_instance_sync_tbl( c_inst_rec ).location_type_code = 'HZ_PARTY_SITES' THEN

2896: -- instance is passed as HZ_PARTY_SITES, location ID should be fetched from HZ_PARTY_SITES table
2897: IF (l_csi_debug_level > 0) THEN
2898: debug( 'px_instance_sync_tbl( c_inst_rec ).location_type_code : '||px_instance_sync_tbl( c_inst_rec ).location_type_code);
2899: END IF;
2900: IF px_instance_sync_tbl( c_inst_rec ).location_type_code = 'HZ_PARTY_SITES' THEN
2901: BEGIN
2902: SELECT location_id
2903: INTO l_location_id
2904: FROM HZ_PARTY_SITES

Line 2904: FROM HZ_PARTY_SITES

2900: IF px_instance_sync_tbl( c_inst_rec ).location_type_code = 'HZ_PARTY_SITES' THEN
2901: BEGIN
2902: SELECT location_id
2903: INTO l_location_id
2904: FROM HZ_PARTY_SITES
2905: WHERE party_site_id = px_instance_sync_tbl( c_inst_rec ).location_id;
2906: debug( 'l_location_id fetched from HZ_PARTY_SITES : '||l_location_id);
2907: EXCEPTION
2908: WHEN OTHERS THEN

Line 2906: debug( 'l_location_id fetched from HZ_PARTY_SITES : '||l_location_id);

2902: SELECT location_id
2903: INTO l_location_id
2904: FROM HZ_PARTY_SITES
2905: WHERE party_site_id = px_instance_sync_tbl( c_inst_rec ).location_id;
2906: debug( 'l_location_id fetched from HZ_PARTY_SITES : '||l_location_id);
2907: EXCEPTION
2908: WHEN OTHERS THEN
2909: l_location_id := px_instance_sync_tbl( c_inst_rec ).location_id;
2910: END;