APPS.WIP_JOBCLOSE_PRIV dependencies on WSM_SM_STARTING_JOBS

Line 146: FROM wsm_sm_starting_jobs sj,

142: AND WOY.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
143: AND (WE.ENTITY_TYPE <> 5 OR
144: (WE.ENTITY_TYPE = 5 AND NOT EXISTS
145: (SELECT 'X'
146: FROM wsm_sm_starting_jobs sj,
147: wsm_split_merge_transactions wmt
148: WHERE sj.wip_entity_id = we.wip_entity_id
149: AND sj.transaction_id = wmt.transaction_id
150: AND (wmt.status <> 4 or nvl(wmt.costed,1) <> 4))))