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.BOM_VALIDATE_SUB_OP_RES dependencies on DUAL

Line 67: FROM SYS.DUAL

63: , p_resource_id NUMBER
64: , p_sub_group_num NUMBER )
65: IS
66: SELECT 'Sub Res does not exist'
67: FROM SYS.DUAL
68: WHERE EXISTS (SELECT NULL
69: FROM WIP_DISCRETE_JOBS wdj
70: WHERE wdj.lot_number = p_lot_number
71: AND (wdj.status_type <> 1

Line 90: FROM DUAL

86: , p_resource_id NUMBER
87: , p_sub_group_num NUMBER )
88: IS
89: SELECT 'Sub Res does not exist'
90: FROM DUAL
91: WHERE NOT EXISTS ( SELECT NULL
92: FROM WIP_DISCRETE_JOBS wdj
93: WHERE wdj.lot_number = p_lot_number
94: AND wdj.status_type = 1

Line 111: FROM SYS.DUAL

107: , p_resource_id NUMBER
108: , p_sub_group_num NUMBER )
109: IS
110: SELECT 'Sub Res does not exist'
111: FROM SYS.DUAL
112: WHERE EXISTS (SELECT NULL
113: FROM WIP_DISCRETE_JOBS wdj
114: , WIP_ENTITIES we
115: , WIP_ENTITIES we1

Line 141: FROM SYS.DUAL

137:
138:
139: IS
140: SELECT 'Sub Res does not exist'
141: FROM SYS.DUAL
142: WHERE EXISTS (SELECT NULL
143: FROM WIP_DISCRETE_JOBS wdj
144: WHERE (wdj.status_type <> 1
145: OR

Line 253: FROM SYS.DUAL

249: , p_schedule_flag NUMBER
250: )
251: IS
252: SELECT 'Related Schedule Resource does not exist'
253: FROM SYS.DUAL
254: WHERE NOT EXISTS( SELECT NULL
255: FROM BOM_OPERATION_RESOURCES
256: WHERE schedule_flag = p_schedule_flag
257: AND substitute_group_num = p_sub_group_num

Line 269: FROM SYS.DUAL

265: , p_schedule_flag NUMBER
266: )
267: IS
268: SELECT 'Already exists'
269: FROM SYS.DUAL
270: WHERE EXISTS( SELECT NULL
271: FROM BOM_SUB_OPERATION_RESOURCES
272: WHERE schedule_flag = p_schedule_flag
273: AND resource_id <> p_resource_id

Line 322: FROM SYS.DUAL

318: , p_sub_group_num NUMBER
319: )
320: IS
321: SELECT 'Related PO Move Resource does not exist'
322: FROM SYS.DUAL
323: WHERE NOT EXISTS( SELECT NULL
324: FROM BOM_OPERATION_RESOURCES
325: WHERE autocharge_type = l_PO_MOVE
326: AND substitute_group_num = p_sub_group_num

Line 336: FROM SYS.DUAL

332: , p_sub_group_num NUMBER )
333:
334: IS
335: SELECT 'Already exists'
336: FROM SYS.DUAL
337: WHERE EXISTS( SELECT NULL
338: FROM BOM_SUB_OPERATION_RESOURCES
339: WHERE autocharge_type = l_PO_MOVE
340: AND resource_id <> p_resource_id

Line 412: FROM SYS.DUAL

408: , p_schedule_flag NUMBER /* Added for bug 13005178 */
409: )
410: IS
411: SELECT 'Already exists'
412: FROM SYS.DUAL
413: WHERE EXISTS( SELECT NULL
414: FROM BOM_SUB_OPERATION_RESOURCES
415: WHERE principle_flag = 1 -- Yes
416: AND NVL(acd_type, l_ACD_ADD) <> l_ACD_DISABLE

Line 1388: FROM DUAL

1384: , p_op_seq_id NUMBER
1385: )
1386: IS
1387: SELECT 'Rev Sub Op Resource Not Exists'
1388: FROM DUAL
1389: WHERE NOT EXISTS (SELECT NULL
1390: FROM BOM_OPERATION_SEQUENCES bos
1391: , BOM_SUB_OPERATION_RESOURCES bsor
1392: WHERE bsor.substitute_group_num = p_sub_group_num

Line 1409: FROM DUAL

1405: , p_schedule_flag NUMBER /* Added for bug 13005178 */
1406: )
1407: IS
1408: SELECT 'Sub Res Duplicate'
1409: FROM DUAL
1410: WHERE EXISTS ( SELECT NULL
1411: FROM BOM_SUB_OPERATION_RESOURCES
1412: WHERE NVL(ACD_TYPE, 1) = NVL(p_acd_type, 1)
1413: AND BASIS_TYPE = p_basis_type