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_UMP_NONROUTINES_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 2170: ahl_mc_relationships mch,

2166: IS
2167: SELECT 'x'
2168: FROM ahl_applicable_instances appl,
2169: csi_ii_relationships cii,
2170: ahl_mc_relationships mch,
2171: ahl_unit_config_headers uch
2172: WHERE appl.position_id = p_x_nonroutine_rec.position_path_id and
2173: (appl.csi_item_instance_id = cii.subject_id or appl.csi_item_instance_id = cii.object_id) and
2174: to_number(cii.position_reference) = mch.relationship_id and

Line 2731: ahl_mc_relationships mch,

2727: IS
2728: SELECT mch.ata_code
2729: FROM ahl_applicable_instances appl,
2730: csi_ii_relationships cii,
2731: ahl_mc_relationships mch,
2732: ahl_unit_config_headers uch
2733: WHERE appl.position_id = p_position_path_id and
2734: appl.csi_item_instance_id = cii.subject_id and
2735: cii.position_reference = mch.relationship_id and

Line 2741: ahl_mc_relationships mch,

2737: uch.unit_config_header_id = p_unit_config_id
2738: UNION ALL
2739: SELECT mch.ata_code
2740: FROM ahl_applicable_instances appl,
2741: ahl_mc_relationships mch,
2742: ahl_unit_config_headers uch
2743: WHERE appl.position_id = p_position_path_id and
2744: appl.csi_item_instance_id = uch.csi_item_instance_id and
2745: mch.mc_header_id = uch.master_config_id and