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.

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_OPERATION_YIELDS

Line 156: FROM WIP_OPERATION_YIELDS WOY

152: AND MMT.ORGANIZATION_ID = p_organization_id
153: AND MMT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
154: AND NOT EXISTS
155: (SELECT 'X'
156: FROM WIP_OPERATION_YIELDS WOY
157: WHERE WOY.ORGANIZATION_ID = p_organization_id
158: AND WOY.STATUS IN (1, 3)
159: AND WOY.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
160: /* FP for 11.5.10 bug 9411629. Added extra clause to ensure that

Line 263: FROM WIP_OPERATION_YIELDS WOY

259: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
260: AND MMT.ORGANIZATION_ID = p_organization_id
261: AND MMT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
262: AND NOT EXISTS ( SELECT 'X'
263: FROM WIP_OPERATION_YIELDS WOY
264: WHERE WOY.ORGANIZATION_ID = p_organization_id
265: AND WOY.STATUS IN ( 1 , 3)
266: AND WOY.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
267: AND ( WE.ENTITY_TYPE <> 5

Line 371: FROM WIP_OPERATION_YIELDS WOY

367: AND MMT.ORGANIZATION_ID = p_organization_id
368: AND MMT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
369: AND NOT EXISTS
370: (SELECT 'X'
371: FROM WIP_OPERATION_YIELDS WOY
372: WHERE WOY.ORGANIZATION_ID = p_organization_id
373: AND WOY.STATUS IN (1, 3)
374: AND WOY.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
375: AND (WE.ENTITY_TYPE <> 5 OR

Line 781: FROM WIP_OPERATION_YIELDS

777: AND TRANSACTION_SOURCE_TYPE_ID = 5
778: AND ORGANIZATION_ID = p_organization_id
779: UNION ALL
780: SELECT DISTINCT WIP_ENTITY_ID
781: FROM WIP_OPERATION_YIELDS
782: WHERE ORGANIZATION_ID = p_organization_id
783: AND STATUS IN (1, 3)
784: UNION ALL
785: SELECT WLC.WIP_ENTITY_ID