DBA Data[Home] [Help]

APPS.WSM_WSMPNTXN_XMLP_PKG dependencies on WSM_SM_RESULTING_JOBS

Line 72: WSM_SM_RESULTING_JOBS RJ,

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

Line 272: WSM_SM_RESULTING_JOBS RJ,

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

Line 310: WSM_SM_RESULTING_JOBS RJ,

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