APPS.AHL_PRD_WORKORDER_PVT dependencies on CSI_II_RELATIONSHIPS

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

3440: AND AWO.workorder_id = p_workorder_id
3441: AND ACTIVE_START_DATE <= SYSDATE
3442: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
3443: AND LOCATION_TYPE_CODE = 'WIP'
3444: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
3445: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
3446: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3447: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE,SYSDATE) AND NVL(ACTIVE_END_DATE,SYSDATE));
3448: