[Home] [Help]
3241: BEGIN
3242: select 1
3243: into l_dummy
3244: from wsm_split_merge_transactions wsmt,
3245: wsm_sm_resulting_jobs wrj,
3246: wip_entities we
3247: where wrj.wip_entity_id = p_wip_entity_id
3248: and wrj.transaction_id = wsmt.transaction_id
3249: and wsmt.transaction_type_id in (1,2,6)
4056: and sj.transaction_id = wmt.transaction_id
4057: and (wmt.status <> 4 or nvl(wmt.costed,1) <> 4))
4058: or exists (
4059: select 1
4060: from wsm_sm_resulting_jobs rj,
4061: wsm_split_merge_transactions wmt
4062: --Bug 4744794: join based on wip_entity_id is replaced with
4063: -- join based on wip_entity_name so that index is used.
4064: --where rj.wip_entity_id = wt.wip_entity_id
5029: SELECT 1
5030: INTO l_rj_rowcount
5031: FROM dual
5032: WHERE exists (select 'Unprocessed WSRJ/WSMT Record exists'
5033: FROM WSM_SM_RESULTING_JOBS WSRJ,
5034: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
5035: WHERE
5036: WSRJ.wip_entity_id = p_wip_entity_id
5037: AND WSMT.transaction_id = WSRJ.transaction_id
5054: SELECT 1
5055: INTO l_rj_rowcount
5056: FROM dual
5057: WHERE exists (select 'Unprocessed WSRJ/WSMT Record exists'
5058: FROM WSM_SM_RESULTING_JOBS WSRJ,
5059: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
5060: WHERE
5061: WSRJ.wip_entity_id = p_wip_entity_id
5062: AND WSMT.transaction_id = WSRJ.transaction_id
5096: SELECT 1
5097: INTO l_rj_rowcount
5098: FROM dual
5099: WHERE exists (select 'Unprocessed WSRJ/WSMT Record exists'
5100: FROM WSM_SM_RESULTING_JOBS WSRJ,
5101: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
5102: WHERE
5103: WSRJ.wip_entity_name = p_wip_entity_name
5104: AND WSMT.organization_id = decode(p_organization_id,
5124: SELECT 1
5125: INTO l_rj_rowcount
5126: FROM dual
5127: WHERE exists (select 'Unprocessed WSRJ/WSMT Record exists'
5128: FROM WSM_SM_RESULTING_JOBS WSRJ,
5129: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
5130: WHERE
5131: WSRJ.wip_entity_name = p_wip_entity_name
5132: AND WSMT.organization_id = decode(p_organization_id,