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 4674: From dual

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

Line 4698: From dual

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

Line 4812: From dual

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

Line 4836: From dual

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

Line 4968: FROM dual

4964: Begin
4965:
4966: SELECT 1
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

Line 4994: FROM dual

4990: Begin
4991:
4992: SELECT 1
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

Line 5031: FROM dual

5027: Begin
5028:
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

Line 5056: FROM dual

5052: Begin
5053:
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

Line 5098: FROM dual

5094: Begin
5095:
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

Line 5126: FROM dual

5122: Begin
5123:
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

Line 5358: FROM dual

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

Line 5395: FROM dual

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

Line 5431: FROM dual

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

Line 5462: FROM dual

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

Line 5543: From dual

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

Line 5603: From dual

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