APPS.AHL_PRD_WORKORDER_PVT dependencies on CSI_II_RELATIONSHIPS

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

4491: AND AWO.workorder_id = p_workorder_id
4492: AND ACTIVE_START_DATE <= SYSDATE
4493: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
4494: AND LOCATION_TYPE_CODE = 'WIP'
4495: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
4496: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
4497: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4498: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE,SYSDATE) AND NVL(ACTIVE_END_DATE,SYSDATE));
4499: