APPS.WSMPUTIL dependencies on WSM_SPLIT_MERGE_TXN_INTERFACE

Line 4073: wsm_split_merge_txn_interface wsmti

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

Line 4080: wsm_split_merge_txn_interface wsmti

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

Line 5361: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI

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

Line 5398: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI

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

Line 5434: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI

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

Line 5465: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI

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