APPS.WSMPUTIL dependencies on WSM_SPLIT_MERGE_TXN_INTERFACE

Line 4071: wsm_split_merge_txn_interface wsmti

4067: and (wmt.status <> 4 or nvl(wmt.costed,1) <> 4))
4068: or exists (
4069: select 1
4070: from wsm_starting_jobs_interface wsji,
4071: wsm_split_merge_txn_interface wsmti
4072: where wsji.wip_entity_id = wt.wip_entity_id
4073: and wsmti.header_id = wsji.header_id
4074: and wsmti.process_status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))
4075: or exists (

Line 4078: wsm_split_merge_txn_interface wsmti

4074: and wsmti.process_status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))
4075: or exists (
4076: select 1
4077: from wsm_resulting_jobs_interface wrji,
4078: wsm_split_merge_txn_interface wsmti
4079: where wrji.wip_entity_name = wt.wip_entity_name
4080: and wsmti.header_id = wrji.header_id
4081: and wsmti.process_status in (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.RUNNING))
4082: --Bug 4744794: Separate SQLs are used to select the records for the cases

Line 5364: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI

5360: INTO l_sj_rowcount
5361: FROM dual
5362: WHERE exists (select 'Unprocessed WSJI/WSMTI Record exists'
5363: FROM WSM_STARTING_JOBS_INTERFACE WSJI,
5364: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5365: WHERE WSJI.wip_entity_id = p_wip_entity_id
5366: AND WSMTI.header_id = WSJI.header_id
5367: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,
5368: WIP_CONSTANTS.RUNNING,

Line 5401: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI

5397: INTO l_rj_rowcount
5398: FROM dual
5399: WHERE exists (select 'Unprocessed WRJI/WSMTI Record exists'
5400: FROM WSM_RESULTING_JOBS_INTERFACE WRJI,
5401: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5402: WHERE WRJI.wip_entity_name = l_wip_entity_name
5403: AND WSMTI.organization_id = l_organization_id
5404: AND WSMTI.header_id = WRJI.header_id
5405: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,

Line 5437: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI

5433: INTO l_sj_rowcount
5434: FROM dual
5435: WHERE exists (select 'Unprocessed WSJI/WSMTI Record exists'
5436: FROM WSM_STARTING_JOBS_INTERFACE WSJI,
5437: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5438: WHERE WSJI.wip_entity_name = p_wip_entity_name
5439: AND WSMTI.organization_id = p_organization_id
5440: AND WSMTI.header_id = WSJI.header_id
5441: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,

Line 5468: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI

5464: INTO l_rj_rowcount
5465: FROM dual
5466: WHERE exists (select 'Unprocessed WRJI/WSMTI Record exists'
5467: FROM WSM_RESULTING_JOBS_INTERFACE WRJI,
5468: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5469: WHERE WRJI.wip_entity_name = p_wip_entity_name
5470: AND WSMTI.organization_id = p_organization_id
5471: AND WSMTI.header_id = WRJI.header_id
5472: AND WSMTI.process_status IN (WIP_CONSTANTS.PENDING,