DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on CSI_II_RELATIONSHIPS

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

10461: AND AWO.workorder_id = p_workorder_id
10462: AND ACTIVE_START_DATE <= SYSDATE
10463: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
10464: AND LOCATION_TYPE_CODE = 'WIP'
10465: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
10466: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
10467: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
10468: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE,SYSDATE) AND NVL(ACTIVE_END_DATE,SYSDATE));
10469: