[Home] [Help]
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
669: AND operation_sequence_id = p_op_seq_id
670: ) ;
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
684: AND bor.resource_seq_num <> p_res_seq_num
685: AND bor.operation_sequence_id = old_operation_sequence_id
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
742: AND resource_seq_num <> p_res_seq_num
743: AND schedule_seq_num = p_sch_seq_num
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)
759: AND bor.resource_seq_num <> p_res_seq_num
760: AND bor.operation_sequence_id = old_operation_sequence_id
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
778: AND resource_seq_num <> p_res_seq_num
779: AND schedule_seq_num = p_sch_seq_num
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)
795: AND bor.resource_seq_num <> p_res_seq_num
796: AND bor.operation_sequence_id = old_operation_sequence_id
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
906: AND operation_sequence_id = p_op_seq_id
907: ) ;
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
920: AND bor.resource_seq_num <> p_res_seq_num
921: AND bor.operation_sequence_id = old_operation_sequence_id
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
1124: AND nvl(substitute_group_num, resource_seq_num) = nvl(p_sub_group_num, p_res_seq_num)
1125: AND resource_seq_num <> p_res_seq_num
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
1140: AND bor.substitute_group_num = p_sub_group_num
1141: AND bor.resource_seq_num <> p_res_seq_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
1195: and substitute_group_num <> p_sub_grp_num /* is not null*/
1196: and resource_seq_num <> p_res_seq_num);
1213: Cursor Check1 is
1214: select substitute_group_num,
1215: min(schedule_seq_num) mn_ssn1, min(resource_seq_num) mn_rsn1,
1216: max(schedule_seq_num) mx_ssn1, max(resource_seq_num) mx_rsn1
1217: from bom_operation_resources
1218: where operation_sequence_id = p_op_seq_id
1219: and substitute_group_num is not null
1220: group by substitute_group_num
1221: order by substitute_group_num;
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
2097: AND bor.operation_sequence_id = bos.old_operation_sequence_id
2098: AND bos.operation_sequence_id = p_op_seq_id
2099: ) ;
2109: FROM BOM_SUB_OPERATION_RESOURCES
2110: WHERE operation_sequence_id = p_op_seq_id
2111: AND substitute_group_num = p_sub_group_num )
2112: AND NOT EXISTS ( SELECT NULL
2113: FROM BOM_OPERATION_RESOURCES
2114: WHERE substitute_group_num = p_sub_group_num
2115: AND resource_seq_num <> p_res_seq_num
2116: AND operation_sequence_id = p_op_seq_id ) ;
2117:
2128: WHERE bsor.substitute_group_num = p_sub_group_num
2129: AND bsor.operation_sequence_id = bos.old_operation_sequence_id
2130: AND bos.operation_sequence_id = p_op_seq_id )
2131: AND NOT EXISTS (SELECT NULL
2132: FROM BOM_OPERATION_RESOURCES bor
2133: , BOM_OPERATION_SEQUENCES bos
2134: WHERE bor.substitute_group_num = p_sub_group_num
2135: AND resource_seq_num <> p_res_seq_num
2136: AND bor.operation_sequence_id = bos.old_operation_sequence_id
3488: l_same_rsc_ssn := 0;
3489:
3490: SELECT COUNT(1)
3491: INTO l_same_rsc_ssn
3492: FROM BOM_OPERATION_RESOURCES
3493: WHERE
3494: SCHEDULE_SEQ_NUM = p_sch_seq_num
3495: AND p_sch_seq_num IS NOT NULL
3496: AND SCHEDULE_SEQ_NUM IS NOT NULL
3526: l_resource_id number;
3527:
3528: CURSOR l_sch_res_cur IS
3529: SELECT resource_id
3530: FROM bom_operation_resources
3531: WHERE operation_sequence_id = p_op_seq_id
3532: AND resource_seq_num <> p_res_seq_num
3533: AND nvl(schedule_seq_num,resource_seq_num) = nvl(p_sch_seq_num,p_res_seq_num)
3534: AND schedule_flag not in (p_sch_flag,l_NO_SCHEDULE)