DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_OPERATION_YIELDS

Line 139: FROM WIP_OPERATION_YIELDS WOY

135: AND MMT.ORGANIZATION_ID = p_organization_id
136: AND MMT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
137: AND NOT EXISTS
138: (SELECT 'X'
139: FROM WIP_OPERATION_YIELDS WOY
140: WHERE WOY.ORGANIZATION_ID = p_organization_id
141: AND WOY.STATUS IN (1, 3)
142: AND WOY.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
143: AND (WE.ENTITY_TYPE <> 5 OR

Line 514: FROM WIP_OPERATION_YIELDS

510: AND TRANSACTION_SOURCE_TYPE_ID = 5
511: AND ORGANIZATION_ID = p_organization_id
512: UNION ALL
513: SELECT DISTINCT WIP_ENTITY_ID
514: FROM WIP_OPERATION_YIELDS
515: WHERE ORGANIZATION_ID = p_organization_id
516: AND STATUS IN (1, 3)
517: UNION ALL
518: SELECT WLC.WIP_ENTITY_ID