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_OP_RES dependencies on DUAL

Line 73: FROM SYS.DUAL

69: , p_rev_item_id NUMBER
70: )
71: IS
72: SELECT 'Op Res does not exist'
73: FROM SYS.DUAL
74: WHERE EXISTS (SELECT NULL
75: FROM WIP_DISCRETE_JOBS wdj
76: WHERE (wdj.status_type <> 1
77: OR

Line 96: FROM SYS.DUAL

92: , p_resource_seq_num NUMBER
93: , p_organization_Id NUMBER )
94: IS
95: SELECT 'Op Res does not exist'
96: FROM SYS.DUAL
97: WHERE EXISTS (SELECT NULL
98: FROM WIP_DISCRETE_JOBS wdj
99: , WIP_ENTITIES we
100: , WIP_ENTITIES we1

Line 125: FROM SYS.DUAL

121:
122:
123: IS
124: SELECT 'Op Res does not exist'
125: FROM SYS.DUAL
126: WHERE EXISTS (SELECT NULL
127: FROM WIP_DISCRETE_JOBS wdj
128: WHERE (wdj.status_type <> 1
129: OR

Line 410: FROM DUAL

406: , p_op_seq_id NUMBER
407: )
408: IS
409: SELECT 'Resource is invalid'
410: FROM DUAL
411: WHERE NOT EXISTS(
412: SELECT NULL
413: FROM BOM_OPERATION_SEQUENCES bos
414: , BOM_DEPARTMENT_RESOURCES bdr

Line 448: FROM DUAL

444: , p_op_seq_id NUMBER
445: )
446: IS
447: SELECT 'Activity is invalid'
448: FROM DUAL
449: WHERE NOT EXISTS(
450: SELECT NULL
451: FROM bom_operational_routings bor
452: , BOM_OPERATION_SEQUENCES bos

Line 489: FROM DUAL

485: )
486: IS
487:
488: SELECT 'Setup Id is invalid'
489: FROM DUAL
490: WHERE NOT EXISTS(
491: SELECT NULL
492: FROM BOM_RESOURCE_SETUPS brs
493: , BOM_SETUP_TYPES bst

Line 664: FROM SYS.DUAL

660: , p_schedule_flag NUMBER
661: )
662: IS
663: SELECT 'Already exists'
664: FROM SYS.DUAL
665: WHERE EXISTS( SELECT NULL
666: FROM BOM_OPERATION_RESOURCES
667: WHERE schedule_flag = p_schedule_flag
668: AND resource_seq_num <> p_res_seq_num

Line 679: FROM SYS.DUAL

675: , p_schedule_flag NUMBER
676: )
677: IS
678: SELECT 'Already exists'
679: FROM SYS.DUAL
680: WHERE EXISTS( SELECT NULL
681: FROM BOM_OPERATION_RESOURCES bor
682: , BOM_OPERATION_SEQUENCES bos
683: WHERE bor.schedule_flag = p_schedule_flag

Line 737: FROM SYS.DUAL

733: , p_schedule_flag NUMBER
734: )
735: IS
736: SELECT 'Already exists'
737: FROM SYS.DUAL
738: WHERE EXISTS( SELECT NULL
739: FROM BOM_OPERATION_RESOURCES
740: WHERE schedule_flag NOT IN (p_schedule_flag, l_NO_SCHEDULE)
741: AND operation_sequence_id = p_op_seq_id

Line 754: FROM SYS.DUAL

750: , p_schedule_flag NUMBER
751: )
752: IS
753: SELECT 'Already exists'
754: FROM SYS.DUAL
755: WHERE EXISTS( SELECT NULL
756: FROM BOM_OPERATION_RESOURCES bor
757: , BOM_OPERATION_SEQUENCES bos
758: WHERE bor.schedule_flag NOT IN (p_schedule_flag, l_NO_SCHEDULE)

Line 773: FROM SYS.DUAL

769: , p_schedule_flag NUMBER
770: )
771: IS
772: SELECT 'Already exists'
773: FROM SYS.DUAL
774: WHERE EXISTS( SELECT NULL
775: FROM BOM_OPERATION_RESOURCES
776: WHERE schedule_flag IN (L_PRIOR, L_NEXT)
777: AND operation_sequence_id = p_op_seq_id

Line 790: FROM SYS.DUAL

786: , p_schedule_flag NUMBER
787: )
788: IS
789: SELECT 'Already exists'
790: FROM SYS.DUAL
791: WHERE EXISTS( SELECT NULL
792: FROM BOM_OPERATION_RESOURCES bor
793: , BOM_OPERATION_SEQUENCES bos
794: WHERE bor.schedule_flag IN (L_PRIOR, L_NEXT)

Line 865: FROM SYS.DUAL

861: , p_organization_id NUMBER
862: )
863: IS
864: SELECT 'Not OSP Resource'
865: FROM SYS.DUAL
866: WHERE EXISTS ( SELECT NULL
867: FROM BOM_RESOURCES
868: WHERE resource_id = p_resource_id
869: AND organization_id = p_organization_id

Line 901: FROM SYS.DUAL

897: , p_res_seq_num NUMBER
898: )
899: IS
900: SELECT 'Already exists'
901: FROM SYS.DUAL
902: WHERE EXISTS( SELECT NULL
903: FROM BOM_OPERATION_RESOURCES
904: WHERE autocharge_type = l_PO_MOVE
905: AND resource_seq_num <> p_res_seq_num

Line 915: FROM SYS.DUAL

911: , p_res_seq_num NUMBER
912: )
913: IS
914: SELECT 'Already exists'
915: FROM SYS.DUAL
916: WHERE EXISTS( SELECT NULL
917: FROM BOM_OPERATION_RESOURCES bor
918: , BOM_OPERATION_SEQUENCES bos
919: WHERE bor.autocharge_type = l_PO_MOVE

Line 964: FROM SYS.DUAL

960: IS
961: CURSOR l_dept_loc_csr ( p_op_seq_id NUMBER)
962: IS
963: SELECT 'No Dept Location'
964: FROM SYS.DUAL
965: WHERE NOT EXISTS( SELECT NULL
966: FROM BOM_OPERATION_SEQUENCES bos
967: , BOM_DEPARTMENTS bd
968: WHERE bd.location_id IS NOT NULL

Line 1049: FROM SYS.DUAL

1045: , p_hour_uom_code VARCHAR2
1046: )
1047: IS
1048: SELECT 'Unable to convert'
1049: FROM SYS.DUAL
1050: WHERE NOT EXISTS(
1051: SELECT NULL
1052: FROM MTL_UOM_CONVERSIONS muc1,
1053: MTL_UOM_CONVERSIONS muc2

Line 1119: FROM SYS.DUAL

1115: , p_sub_group_num NUMBER
1116: )
1117: IS
1118: SELECT 'Already exists'
1119: FROM SYS.DUAL
1120: WHERE EXISTS( SELECT NULL
1121: FROM BOM_OPERATION_RESOURCES
1122: WHERE principle_flag = 1 -- Yes
1123: AND NVL(acd_type, l_ACD_ADD) <> l_ACD_DISABLE

Line 1135: FROM SYS.DUAL

1131: , p_sub_group_num NUMBER
1132: )
1133: IS
1134: SELECT 'Already exists'
1135: FROM SYS.DUAL
1136: WHERE EXISTS( SELECT NULL
1137: FROM BOM_OPERATION_RESOURCES bor
1138: , BOM_OPERATION_SEQUENCES bos
1139: WHERE bor.principle_flag = 1 -- Yes

Line 1190: select 1 from dual

1186: IS
1187: /* Fix for bug 4506885 - Modified the cursor c_same_sign to check for substitute_group_num <> p_sub_grp_num.
1188: Previously it was checking for substitute_group_num is not null. */
1189: cursor c_same_sgn is
1190: select 1 from dual
1191: where exists (select 1 --schedule_seq_num, count(distinct(substitute_group_num)) sgn_count
1192: from bom_operation_resources
1193: where operation_sequence_id = p_op_seq_id
1194: and schedule_seq_num = p_sch_seq_num

Line 2092: FROM DUAL

2088: , p_op_seq_id NUMBER
2089: )
2090: IS
2091: SELECT 'Rev Op Resource Not Exists'
2092: FROM DUAL
2093: WHERE NOT EXISTS (SELECT NULL
2094: FROM BOM_OPERATION_SEQUENCES bos
2095: , BOM_OPERATION_RESOURCES bor
2096: WHERE bor.resource_seq_num = p_res_seq_num

Line 2107: FROM SYS.DUAL

2103: , p_sub_group_num IN NUMBER
2104: , p_res_seq_num IN NUMBER)
2105: IS
2106: SELECT 'Sub Res Exists'
2107: FROM SYS.DUAL
2108: WHERE EXISTS ( SELECT NULL
2109: FROM BOM_SUB_OPERATION_RESOURCES
2110: WHERE operation_sequence_id = p_op_seq_id
2111: AND substitute_group_num = p_sub_group_num )

Line 2124: FROM SYS.DUAL

2120: , p_sub_group_num IN NUMBER
2121: , p_res_seq_num IN NUMBER)
2122: IS
2123: SELECT 'Sub Res Exists'
2124: FROM SYS.DUAL
2125: WHERE EXISTS ( SELECT NULL
2126: FROM BOM_SUB_OPERATION_RESOURCES bsor
2127: , BOM_OPERATION_SEQUENCES bos
2128: WHERE bsor.substitute_group_num = p_sub_group_num

Line 2146: FROM SYS.DUAL

2142: CURSOR l_subres_pomove_csr ( p_op_seq_id IN NUMBER
2143: , p_sub_group_num IN NUMBER )
2144: IS
2145: SELECT 'Sub PO Move Exists'
2146: FROM SYS.DUAL
2147: WHERE EXISTS ( SELECT NULL
2148: FROM BOM_SUB_OPERATION_RESOURCES
2149: WHERE autocharge_type = l_PO_MOVE
2150: AND substitute_group_num = p_sub_group_num

Line 2157: FROM SYS.DUAL

2153: CURSOR l_rev_subres_pomove_csr ( p_op_seq_id IN NUMBER
2154: , p_sub_group_num IN NUMBER )
2155: IS
2156: SELECT 'Sub PO Move Exists'
2157: FROM SYS.DUAL
2158: WHERE EXISTS ( SELECT NULL
2159: FROM BOM_SUB_OPERATION_RESOURCES bsor
2160: , BOM_OPERATION_SEQUENCES bos
2161: WHERE autocharge_type = l_PO_MOVE

Line 2174: FROM SYS.DUAL

2170: , p_sub_group_num IN NUMBER
2171: , p_schedule_flag IN NUMBER )
2172: IS
2173: SELECT 'Sub PO Move Exists'
2174: FROM SYS.DUAL
2175: WHERE EXISTS ( SELECT NULL
2176: FROM BOM_SUB_OPERATION_RESOURCES
2177: WHERE schedule_flag = p_schedule_flag
2178: AND substitute_group_num = p_sub_group_num

Line 2187: FROM SYS.DUAL

2183: , p_sub_group_num IN NUMBER
2184: , p_schedule_flag IN NUMBER )
2185: IS
2186: SELECT 'Sub PO Move Exists'
2187: FROM SYS.DUAL
2188: WHERE EXISTS ( SELECT NULL
2189: FROM BOM_SUB_OPERATION_RESOURCES bsor
2190: , BOM_OPERATION_SEQUENCES bos
2191: WHERE bsor.schedule_flag = p_schedule_flag