APPS.WIP_JOBCLOSE_PRIV dependencies on WSM_SPLIT_MERGE_TRANSACTIONS

Line 180: wsm_split_merge_transactions wmt

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))))
184: AND (WE.ENTITY_TYPE <> 5 OR

Line 188: wsm_split_merge_transactions wmt

184: AND (WE.ENTITY_TYPE <> 5 OR
185: (WE.ENTITY_TYPE = 5 AND NOT EXISTS
186: (SELECT 'X'
187: FROM wsm_sm_resulting_jobs rj,
188: wsm_split_merge_transactions wmt
189: WHERE rj.wip_entity_id = we.wip_entity_id
190: AND rj.transaction_id = wmt.transaction_id
191: AND (wmt.status <> 4 or nvl(wmt.costed,1) <> 4))))))
192:

Line 271: WSM_SPLIT_MERGE_TRANSACTIONS WMT

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))))
275: AND ( WE.ENTITY_TYPE <> 5

Line 279: WSM_SPLIT_MERGE_TRANSACTIONS WMT

275: AND ( WE.ENTITY_TYPE <> 5
276: OR ( WE.ENTITY_TYPE = 5
277: AND NOT EXISTS ( SELECT 'X'
278: FROM WSM_SM_RESULTING_JOBS RJ ,
279: WSM_SPLIT_MERGE_TRANSACTIONS WMT
280: WHERE RJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
281: AND RJ.TRANSACTION_ID = WMT.TRANSACTION_ID
282: AND ( WMT.STATUS <> 4 OR NVL ( WMT.COSTED , 1) <> 4))))))
283: /*for bug 8808014(FP 8674750), exclude CMRO work order*/

Line 379: wsm_split_merge_transactions wmt

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))))
383: AND (WE.ENTITY_TYPE <> 5 OR

Line 387: wsm_split_merge_transactions wmt

383: AND (WE.ENTITY_TYPE <> 5 OR
384: (WE.ENTITY_TYPE = 5 AND NOT EXISTS
385: (SELECT 'X'
386: FROM wsm_sm_resulting_jobs rj,
387: wsm_split_merge_transactions wmt
388: WHERE rj.wip_entity_id = we.wip_entity_id
389: AND rj.transaction_id = wmt.transaction_id
390: AND (wmt.status <> 4 or nvl(wmt.costed,1) <> 4))))))
391: /*Fix for 8808014(FP 8674750), added validation for CMRO, check whether the CMRO