APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSM_SM_RESULTING_JOBS

Line 20308: from wsm_sm_resulting_jobs

20304: and wip_entity_id = p_wip_entity_id)
20305: /* ST bug fix 3493984 : commented this code */
20306: /*or exists (
20307: select 'x'
20308: from wsm_sm_resulting_jobs
20309: where organization_id = p_organization_id
20310: and wip_entity_id = p_wip_entity_id) */
20311: /* ST bug fix 3493984 : Added code to consider only successful WIP lot transactions */
20312: or exists (

Line 20314: from wsm_sm_resulting_jobs wsrj

20310: and wip_entity_id = p_wip_entity_id) */
20311: /* ST bug fix 3493984 : Added code to consider only successful WIP lot transactions */
20312: or exists (
20313: select 'x'
20314: from wsm_sm_resulting_jobs wsrj
20315: where wsrj.organization_id = p_organization_id
20316: and wsrj.wip_entity_id = p_wip_entity_id
20317: and exists (select transaction_id
20318: from wsm_split_merge_transactions wsmt

Line 20376: from wsm_sm_resulting_jobs

20372: where organization_id = p_organization_id
20373: and wip_entity_id = p_wip_entity_id)
20374: or exists (
20375: select 'x'
20376: from wsm_sm_resulting_jobs
20377: where organization_id = p_organization_id
20378: and wip_entity_id = p_wip_entity_id)
20379: or exists (
20380: select 'x'