eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on CSI_II_RELATIONSHIPS

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

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'
400: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
401: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
402: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
403: AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE,SYSDATE) AND NVL(ACTIVE_END_DATE,SYSDATE))))
404: GROUP BY DJ.WIP_ENTITY_ID, DJ.ORGANIZATION_ID, WE.WIP_ENTITY_NAME,