DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WSM_STARTING_JOBS_INTERFACE

Line 4070: from wsm_starting_jobs_interface wsji,

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

Line 5363: FROM WSM_STARTING_JOBS_INTERFACE WSJI,

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

Line 5436: FROM WSM_STARTING_JOBS_INTERFACE WSJI,

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