58: UNION ALL
59: SELECT
60: SJ.WIP_ENTITY_ID
61: FROM
62: WSM_SM_STARTING_JOBS SJ,
63: WSM_SPLIT_MERGE_TRANSACTIONS WMT
64: WHERE SJ.TRANSACTION_ID = WMT.TRANSACTION_ID
65: AND ( WMT.STATUS <> 4
66: OR NVL(WMT.COSTED
258: WHERE exists (
259: SELECT
260: 1
261: FROM
262: WSM_SM_STARTING_JOBS SJ,
263: WSM_SPLIT_MERGE_TRANSACTIONS WMT
264: WHERE SJ.WIP_ENTITY_ID = WIP_ENTITY_ID_1
265: AND SJ.TRANSACTION_ID = WMT.TRANSACTION_ID
266: AND WMT.ORGANIZATION_ID = P_ORGANIZATION_ID
295: WHERE exists (
296: SELECT
297: 1
298: FROM
299: WSM_SM_STARTING_JOBS SJ,
300: WSM_SPLIT_MERGE_TRANSACTIONS WMT
301: WHERE SJ.WIP_ENTITY_ID = WIP_ENTITY_ID_1
302: AND SJ.TRANSACTION_ID = WMT.TRANSACTION_ID
303: AND WMT.ORGANIZATION_ID = P_ORGANIZATION_ID