DBA Data[Home] [Help]

APPS.AHL_PRD_DF_PVT dependencies on CSI_II_RELATIONSHIPS

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

3788: AND AWO.workorder_id = p_workorder_id
3789: AND ACTIVE_START_DATE <= SYSDATE
3790: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
3791: AND LOCATION_TYPE_CODE = 'WIP'
3792: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
3793: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
3794: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3795: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE,SYSDATE) AND NVL(ACTIVE_END_DATE,SYSDATE));
3796: