APPS.WSMPUTIL dependencies on WSM_SPLIT_MERGE_TRANSACTIONS

Line 3244: from wsm_split_merge_transactions wsmt,

3240:
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

Line 4049: wsm_split_merge_transactions wmt

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
4053: -- Modified SQL back to wip_entity_id for bug 9433681. We cannot use job name since it's updated during completion.

Line 4061: wsm_split_merge_transactions wmt

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
4065: -- Modified SQL back to wip_entity_id for bug 9433681. We cannot use job name since it's updated during completion.

Line 4971: WSM_SPLIT_MERGE_TRANSACTIONS WSMT

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
4975: AND WSMT.status IN (WIP_CONSTANTS.PENDING,

Line 4997: WSM_SPLIT_MERGE_TRANSACTIONS WSMT

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
5001: AND WSMT.status IN (WIP_CONSTANTS.PENDING,

Line 5034: WSM_SPLIT_MERGE_TRANSACTIONS WSMT

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
5038: AND WSMT.status IN (WIP_CONSTANTS.PENDING,

Line 5059: WSM_SPLIT_MERGE_TRANSACTIONS WSMT

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
5063: AND WSMT.status IN (WIP_CONSTANTS.PENDING,

Line 5101: WSM_SPLIT_MERGE_TRANSACTIONS WSMT

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,
5105: 0, WSMT.organization_id, p_organization_id)

Line 5129: WSM_SPLIT_MERGE_TRANSACTIONS WSMT

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,
5133: 0, WSMT.organization_id, p_organization_id)