APPS.WIP_JOBCLOSE_PRIV dependencies on WSM_SM_STARTING_JOBS

Line 179: FROM wsm_sm_starting_jobs sj,

175: AND WLC.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
176: AND (WE.ENTITY_TYPE <> 5 OR
177: (WE.ENTITY_TYPE = 5 AND NOT EXISTS
178: (SELECT 'X'
179: FROM wsm_sm_starting_jobs sj,
180: wsm_split_merge_transactions wmt
181: WHERE sj.wip_entity_id = we.wip_entity_id
182: AND sj.transaction_id = wmt.transaction_id
183: AND (wmt.status <> 4 or nvl(wmt.costed,1) <> 4))))

Line 270: FROM WSM_SM_STARTING_JOBS SJ ,

266: AND WOY.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
267: AND ( WE.ENTITY_TYPE <> 5
268: OR ( WE.ENTITY_TYPE = 5
269: AND NOT EXISTS ( SELECT 'X'
270: FROM WSM_SM_STARTING_JOBS SJ ,
271: WSM_SPLIT_MERGE_TRANSACTIONS WMT
272: WHERE SJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
273: AND SJ.TRANSACTION_ID = WMT.TRANSACTION_ID
274: AND ( WMT.STATUS <> 4 OR NVL ( WMT.COSTED , 1) <> 4))))

Line 378: FROM wsm_sm_starting_jobs sj,

374: AND WOY.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
375: AND (WE.ENTITY_TYPE <> 5 OR
376: (WE.ENTITY_TYPE = 5 AND NOT EXISTS
377: (SELECT 'X'
378: FROM wsm_sm_starting_jobs sj,
379: wsm_split_merge_transactions wmt
380: WHERE sj.wip_entity_id = we.wip_entity_id
381: AND sj.transaction_id = wmt.transaction_id
382: AND (wmt.status <> 4 or nvl(wmt.costed,1) <> 4))))