APPS.WSMPUTIL dependencies on WSM_SM_STARTING_JOBS

Line 4048: from wsm_sm_starting_jobs sj,

4044: and we.organization_id = wt.organization_id
4045: and we.entity_type = 5) -- check only LBJs
4046: and (exists (
4047: select 1
4048: from wsm_sm_starting_jobs sj,
4049: wsm_split_merge_transactions wmt
4050: --Bug 4744794: join based on wip_entity_id is replaced with
4051: -- join based on wip_entity_name so that index is used.
4052: --where sj.wip_entity_id = wt.wip_entity_id

Line 4970: FROM WSM_SM_STARTING_JOBS WSSJ,

4966: SELECT 1
4967: INTO l_sj_rowcount
4968: FROM dual
4969: WHERE exists (select 'Unprocessed WSMT Record exists'
4970: FROM WSM_SM_STARTING_JOBS WSSJ,
4971: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
4972: WHERE
4973: WSSJ.wip_entity_id = p_wip_entity_id
4974: AND WSMT.transaction_id = WSSJ.transaction_id

Line 4996: FROM WSM_SM_STARTING_JOBS WSSJ,

4992: SELECT 1
4993: INTO l_sj_rowcount
4994: FROM dual
4995: WHERE exists (select 'Unprocessed WSSJ/WSMT Record exists'
4996: FROM WSM_SM_STARTING_JOBS WSSJ,
4997: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
4998: WHERE
4999: WSSJ.wip_entity_id = p_wip_entity_id
5000: AND WSMT.transaction_id = WSSJ.transaction_id