DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WSM_STARTING_JOBS_INTERFACE

Line 4072: from wsm_starting_jobs_interface wsji,

4068: and rj.transaction_id = wmt.transaction_id
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))

Line 5360: FROM WSM_STARTING_JOBS_INTERFACE WSJI,

5356: SELECT 1
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,

Line 5433: FROM WSM_STARTING_JOBS_INTERFACE WSJI,

5429: SELECT 1
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