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 DUAL

Line 2811: -- Pushed it under dual exists condition check.

2807: return ret_val1;
2808: else
2809: begin
2810: -- Bug#2872306 - TOPSQL Fix -- BBK
2811: -- Pushed it under dual exists condition check.
2812: -- The purpose of this sql is to find if there are OPEN Lotbased Jobs.
2813: select 1
2814: into ret_val1
2815: from dual

Line 2815: from dual

2811: -- Pushed it under dual exists condition check.
2812: -- The purpose of this sql is to find if there are OPEN Lotbased Jobs.
2813: select 1
2814: into ret_val1
2815: from dual
2816: where exists (select 1
2817: from wip_discrete_jobs wdj, wip_entities we
2818: where wdj.organization_id = p_org_id
2819: and wdj.wip_entity_id = we.wip_entity_id

Line 3119: FROM sys.dual

3115: END IF;
3116:
3117: SELECT 1
3118: INTO l_count
3119: FROM sys.dual
3120: WHERE exists(
3121: select 1
3122: from bom_operation_networks bon
3123: --where NVL(WSMPUTIL.replacement_op_seq_id(

Line 4677: From dual

4673: l_stmt_num := 20;
4674:
4675: SELECT 1
4676: INTO l_rowcount
4677: From dual
4678: where exists (select 'Unprocessed WLMTI Record exists'
4679: FROM WSM_LOT_MOVE_TXN_INTERFACE WLMTI
4680: WHERE WLMTI.entity_type = 5
4681: AND WLMTI.wip_entity_id = p_wip_entity_id

Line 4701: From dual

4697: l_stmt_num := 30;
4698:
4699: SELECT 1
4700: INTO l_rowcount
4701: From dual
4702: where exists (select 'Unprocessed WLMTI Record exists'
4703: FROM WSM_LOT_MOVE_TXN_INTERFACE WLMTI
4704: WHERE WLMTI.entity_type = 5
4705: AND WLMTI.wip_entity_name = p_wip_entity_name

Line 4815: From dual

4811: l_stmt_num := 20;
4812:
4813: SELECT 1
4814: INTO l_rowcount
4815: From dual
4816: where exists (select 'Unprocessed WMTI Record exists'
4817: FROM WIP_MOVE_TXN_INTERFACE WMTI
4818: WHERE WMTI.entity_type = 5
4819: AND WMTI.wip_entity_id = p_wip_entity_id

Line 4839: From dual

4835: l_stmt_num := 60;
4836:
4837: SELECT 1
4838: INTO l_rowcount
4839: From dual
4840: where exists (select 'Unprocessed WMTI Record exists'
4841: FROM WIP_MOVE_TXN_INTERFACE WMTI
4842: WHERE WMTI.entity_type = 5
4843: AND WMTI.wip_entity_name = p_wip_entity_name

Line 4971: FROM dual

4967: Begin
4968:
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

Line 4997: FROM dual

4993: Begin
4994:
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

Line 5034: FROM dual

5030: Begin
5031:
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

Line 5059: FROM dual

5055: Begin
5056:
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

Line 5101: FROM dual

5097: Begin
5098:
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

Line 5129: FROM dual

5125: Begin
5126:
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

Line 5361: FROM dual

5357: Begin
5358:
5359: SELECT 1
5360: INTO l_sj_rowcount
5361: FROM dual
5362: WHERE exists (select 'Unprocessed WSJI/WSMTI Record exists'
5363: FROM WSM_STARTING_JOBS_INTERFACE WSJI,
5364: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5365: WHERE WSJI.wip_entity_id = p_wip_entity_id

Line 5398: FROM dual

5394: Begin
5395:
5396: SELECT 1
5397: INTO l_rj_rowcount
5398: FROM dual
5399: WHERE exists (select 'Unprocessed WRJI/WSMTI Record exists'
5400: FROM WSM_RESULTING_JOBS_INTERFACE WRJI,
5401: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5402: WHERE WRJI.wip_entity_name = l_wip_entity_name

Line 5434: FROM dual

5430: Begin
5431:
5432: SELECT 1
5433: INTO l_sj_rowcount
5434: FROM dual
5435: WHERE exists (select 'Unprocessed WSJI/WSMTI Record exists'
5436: FROM WSM_STARTING_JOBS_INTERFACE WSJI,
5437: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5438: WHERE WSJI.wip_entity_name = p_wip_entity_name

Line 5465: FROM dual

5461: Begin
5462:
5463: SELECT 1
5464: INTO l_rj_rowcount
5465: FROM dual
5466: WHERE exists (select 'Unprocessed WRJI/WSMTI Record exists'
5467: FROM WSM_RESULTING_JOBS_INTERFACE WRJI,
5468: WSM_SPLIT_MERGE_TXN_INTERFACE WSMTI
5469: WHERE WRJI.wip_entity_name = p_wip_entity_name

Line 5546: From dual

5542:
5543: l_stmt_num := 10;
5544:
5545: Select 1 into l_count
5546: From dual
5547: Where Exists ( Select 'Jobs with Qty At this Operation Exists'
5548: from wip_discrete_jobs wdj
5549: , wip_operations wo
5550: Where wdj.wip_entity_id = wo.wip_entity_id

Line 5606: From dual

5602:
5603: l_stmt_num := 10;
5604:
5605: Select 1 into l_count
5606: From dual
5607: Where Exists (
5608: Select 'Jobs with Qty At this Operation Exists'
5609: from bom_operation_sequences bos
5610: , wip_discrete_jobs wdj