68: UNION ALL
69: SELECT
70: RJ.WIP_ENTITY_ID
71: FROM
72: WSM_SM_RESULTING_JOBS RJ,
73: WSM_SPLIT_MERGE_TRANSACTIONS WMT
74: WHERE RJ.TRANSACTION_ID = WMT.TRANSACTION_ID
75: AND ( WMT.STATUS <> 4
76: OR NVL(WMT.COSTED
268: UNION
269: SELECT
270: 1
271: FROM
272: WSM_SM_RESULTING_JOBS RJ,
273: WSM_SPLIT_MERGE_TRANSACTIONS WMT
274: WHERE RJ.WIP_ENTITY_ID = WIP_ENTITY_ID_1
275: AND RJ.TRANSACTION_ID = WMT.TRANSACTION_ID
276: AND WMT.ORGANIZATION_ID = P_ORGANIZATION_ID
306: UNION
307: SELECT
308: 1
309: FROM
310: WSM_SM_RESULTING_JOBS RJ,
311: WSM_SPLIT_MERGE_TRANSACTIONS WMT
312: WHERE RJ.WIP_ENTITY_ID = WIP_ENTITY_ID_1
313: AND RJ.TRANSACTION_ID = WMT.TRANSACTION_ID
314: AND WMT.ORGANIZATION_ID = P_ORGANIZATION_ID