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 4973: FROM WSM_SM_STARTING_JOBS WSSJ,

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

Line 4999: FROM WSM_SM_STARTING_JOBS WSSJ,

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