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.AHL_RA_ANALYSER_PVT dependencies on AHL_RA_SETUPS

Line 1204: and chg.removal_code in (Select Removal_Code from AHL_RA_SETUPS where setup_code = 'REMOVAL_CODE')

1200: csi_item_instances cii,
1201: ahl_prd_dispositions_b dis
1202: where chg.part_change_type IN ('R','S')
1203: and chg.part_change_id = dis.part_change_id
1204: and chg.removal_code in (Select Removal_Code from AHL_RA_SETUPS where setup_code = 'REMOVAL_CODE')
1205: and dis.condition_id in (Select Status_Id from AHL_RA_SETUPS where setup_code = 'ITEM_STATUS')
1206: and chg.mc_relationship_id = to_number(l_path_position_id_tbl(q))
1207: AND cii.instance_id = chg.removed_instance_id
1208: AND cii.inventory_item_id = l_dtls_inv_item_id_tbl(j)

Line 1205: and dis.condition_id in (Select Status_Id from AHL_RA_SETUPS where setup_code = 'ITEM_STATUS')

1201: ahl_prd_dispositions_b dis
1202: where chg.part_change_type IN ('R','S')
1203: and chg.part_change_id = dis.part_change_id
1204: and chg.removal_code in (Select Removal_Code from AHL_RA_SETUPS where setup_code = 'REMOVAL_CODE')
1205: and dis.condition_id in (Select Status_Id from AHL_RA_SETUPS where setup_code = 'ITEM_STATUS')
1206: and chg.mc_relationship_id = to_number(l_path_position_id_tbl(q))
1207: AND cii.instance_id = chg.removed_instance_id
1208: AND cii.inventory_item_id = l_dtls_inv_item_id_tbl(j)
1209: AND cii.inv_master_organization_id = l_dtls_inv_master_org_id_tbl(j)) query_c;

Line 1244: and chg.removal_code in (Select Removal_Code from AHL_RA_SETUPS where setup_code = 'REMOVAL_CODE')

1240: ahl_prd_dispositions_b dis
1241: where chg.part_change_type IN ('R','S')
1242: and chg.part_change_id = dis.part_change_id
1243: AND chg.removed_instance_id = ctr.source_object_id
1244: and chg.removal_code in (Select Removal_Code from AHL_RA_SETUPS where setup_code = 'REMOVAL_CODE')
1245: and dis.condition_id in (Select Status_Id from AHL_RA_SETUPS where setup_code = 'ITEM_STATUS')
1246: and chg.mc_relationship_id = to_number(l_path_position_id_tbl(q))
1247: AND ctr.value_timestamp = (Select max(maxcv.value_timestamp)
1248: from csi_counter_readings maxcv

Line 1245: and dis.condition_id in (Select Status_Id from AHL_RA_SETUPS where setup_code = 'ITEM_STATUS')

1241: where chg.part_change_type IN ('R','S')
1242: and chg.part_change_id = dis.part_change_id
1243: AND chg.removed_instance_id = ctr.source_object_id
1244: and chg.removal_code in (Select Removal_Code from AHL_RA_SETUPS where setup_code = 'REMOVAL_CODE')
1245: and dis.condition_id in (Select Status_Id from AHL_RA_SETUPS where setup_code = 'ITEM_STATUS')
1246: and chg.mc_relationship_id = to_number(l_path_position_id_tbl(q))
1247: AND ctr.value_timestamp = (Select max(maxcv.value_timestamp)
1248: from csi_counter_readings maxcv
1249: where ctr.counter_id = maxcv.counter_id