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_COMPLETIONS_PVT dependencies on CSI_II_RELATIONSHIPS

Line 11292: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR

11288: AND AWO.workorder_id = p_workorder_id
11289: AND ACTIVE_START_DATE <= SYSDATE
11290: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
11291: AND LOCATION_TYPE_CODE = 'WIP'
11292: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
11293: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
11294: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
11295: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE,SYSDATE) AND NVL(ACTIVE_END_DATE,SYSDATE));
11296: