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.

[Home] [Help]

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 410: FROM SYS.DUAL

406: , p_basis_type NUMBER
407: )
408: IS
409: SELECT 'Already exists'
410: FROM SYS.DUAL
411: WHERE EXISTS( SELECT NULL
412: FROM BOM_SUB_OPERATION_RESOURCES
413: WHERE principle_flag = 1 -- Yes
414: AND NVL(acd_type, l_ACD_ADD) <> l_ACD_DISABLE

Line 1358: FROM DUAL

1354: , p_op_seq_id NUMBER
1355: )
1356: IS
1357: SELECT 'Rev Sub Op Resource Not Exists'
1358: FROM DUAL
1359: WHERE NOT EXISTS (SELECT NULL
1360: FROM BOM_OPERATION_SEQUENCES bos
1361: , BOM_SUB_OPERATION_RESOURCES bsor
1362: WHERE bsor.substitute_group_num = p_sub_group_num

Line 1378: FROM DUAL

1374: , p_basis_type NUMBER
1375: )
1376: IS
1377: SELECT 'Sub Res Duplicate'
1378: FROM DUAL
1379: WHERE EXISTS ( SELECT NULL
1380: FROM BOM_SUB_OPERATION_RESOURCES
1381: WHERE NVL(ACD_TYPE, 1) = NVL(p_acd_type, 1)
1382: AND BASIS_TYPE = p_basis_type