eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPUTIL dependencies on WSM_SM_RESULTING_JOBS

Line 3245: wsm_sm_resulting_jobs wrj,

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)

Line 4059: from wsm_sm_resulting_jobs rj,

4055: and sj.transaction_id = wmt.transaction_id
4056: and (wmt.status <> 4 or nvl(wmt.costed,1) <> 4))
4057: or exists (
4058: select 1
4059: from wsm_sm_resulting_jobs rj,
4060: wsm_split_merge_transactions wmt
4061: --Bug 4744794: join based on wip_entity_id is replaced with
4062: -- join based on wip_entity_name so that index is used.
4063: --where rj.wip_entity_id = wt.wip_entity_id

Line 5036: FROM WSM_SM_RESULTING_JOBS WSRJ,

5032: SELECT 1
5033: INTO l_rj_rowcount
5034: FROM dual
5035: WHERE exists (select 'Unprocessed WSRJ/WSMT Record exists'
5036: FROM WSM_SM_RESULTING_JOBS WSRJ,
5037: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
5038: WHERE
5039: WSRJ.wip_entity_id = p_wip_entity_id
5040: AND WSMT.transaction_id = WSRJ.transaction_id

Line 5061: FROM WSM_SM_RESULTING_JOBS WSRJ,

5057: SELECT 1
5058: INTO l_rj_rowcount
5059: FROM dual
5060: WHERE exists (select 'Unprocessed WSRJ/WSMT Record exists'
5061: FROM WSM_SM_RESULTING_JOBS WSRJ,
5062: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
5063: WHERE
5064: WSRJ.wip_entity_id = p_wip_entity_id
5065: AND WSMT.transaction_id = WSRJ.transaction_id

Line 5103: FROM WSM_SM_RESULTING_JOBS WSRJ,

5099: SELECT 1
5100: INTO l_rj_rowcount
5101: FROM dual
5102: WHERE exists (select 'Unprocessed WSRJ/WSMT Record exists'
5103: FROM WSM_SM_RESULTING_JOBS WSRJ,
5104: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
5105: WHERE
5106: WSRJ.wip_entity_name = p_wip_entity_name
5107: AND WSMT.organization_id = decode(p_organization_id,

Line 5131: FROM WSM_SM_RESULTING_JOBS WSRJ,

5127: SELECT 1
5128: INTO l_rj_rowcount
5129: FROM dual
5130: WHERE exists (select 'Unprocessed WSRJ/WSMT Record exists'
5131: FROM WSM_SM_RESULTING_JOBS WSRJ,
5132: WSM_SPLIT_MERGE_TRANSACTIONS WSMT
5133: WHERE
5134: WSRJ.wip_entity_name = p_wip_entity_name
5135: AND WSMT.organization_id = decode(p_organization_id,