APPS.WSM_WSMPNTXN_XMLP_PKG dependencies on WSM_SPLIT_MERGE_TRANSACTIONS

Line 63: WSM_SPLIT_MERGE_TRANSACTIONS WMT

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
67: ,1) <> 4 )

Line 73: WSM_SPLIT_MERGE_TRANSACTIONS WMT

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
77: ,1) <> 4 )

Line 263: WSM_SPLIT_MERGE_TRANSACTIONS WMT

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
267: AND WMT.STATUS <> 4

Line 273: WSM_SPLIT_MERGE_TRANSACTIONS WMT

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
277: AND WMT.STATUS <> 4 );

Line 300: WSM_SPLIT_MERGE_TRANSACTIONS WMT

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
304: AND NVL(WMT.COSTED

Line 311: WSM_SPLIT_MERGE_TRANSACTIONS WMT

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
315: AND NVL(WMT.COSTED