DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on CSI_ITEM_INSTANCES

Line 395: FROM CSI_ITEM_INSTANCES CII

391: /*Fix for 8808014(FP 8674750), added validation for CMRO, check whether the CMRO
392: item is in location_type_code = WIP*/
393: AND (WE.ENTITY_TYPE = 6 AND DJ.MAINTENANCE_OBJECT_SOURCE = 2 AND NOT EXISTS
394: (SELECT 'x'
395: FROM CSI_ITEM_INSTANCES CII
396: WHERE CII.WIP_JOB_ID = WE.WIP_ENTITY_ID
397: AND CII.ACTIVE_START_DATE <= SYSDATE
398: AND ((CII.ACTIVE_END_DATE IS NULL) OR (CII.ACTIVE_END_DATE >= SYSDATE))
399: AND CII.LOCATION_TYPE_CODE = 'WIP'