DBA Data[Home] [Help]

APPS.WSM_WSMPNTXN_XMLP_PKG dependencies on WSM_SM_STARTING_JOBS

Line 62: WSM_SM_STARTING_JOBS SJ,

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

Line 262: WSM_SM_STARTING_JOBS SJ,

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

Line 299: WSM_SM_STARTING_JOBS SJ,

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