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

Line 4194: FROM AHL_MC_RELATIONSHIPS rel, CSI_II_RELATIONSHIPS CSI

4190: WHERE part_change_id = p_part_change_id;
4191: --
4192: CURSOR get_pos_mandatory_csr(p_instance_id IN NUMBER) IS
4193: SELECT rel.position_necessity_code
4194: FROM AHL_MC_RELATIONSHIPS rel, CSI_II_RELATIONSHIPS CSI
4195: WHERE csi.subject_id = p_instance_id
4196: AND rel.relationship_id = TO_NUMBER(CSI.position_reference)
4197: AND CSI.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4198: AND TRUNC(nvl(CSI.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)

Line 4205: ahl_mc_relationships B,

4201: --For fixing bug 4085156, added by Jerry on 12/27/2004
4202: CURSOR get_pos_mandatory(c_path_position_id NUMBER) IS
4203: SELECT B.position_necessity_code
4204: FROM ahl_mc_path_position_nodes A,
4205: ahl_mc_relationships B,
4206: ahl_mc_headers_b C
4207: WHERE A.path_position_id = c_path_position_id
4208: and A.sequence = (select max(D.sequence)
4209: from ahl_mc_path_position_nodes D