APPS.BOM_VALIDATE_OP_RES dependencies on BOM_OPERATION_SEQUENCES

Line 246: FROM BOM_OPERATION_SEQUENCES

242: IS
243: CURSOR l_get_acdtype_csr(p_op_seq_id NUMBER)
244: IS
245: SELECT acd_type
246: FROM BOM_OPERATION_SEQUENCES
247: WHERE operation_sequence_id = p_op_seq_id ;
248: BEGIN
249:
250: FOR l_get_acdtype_rec IN l_get_acdtype_csr(p_op_seq_id => p_op_seq_id)

Line 413: FROM BOM_OPERATION_SEQUENCES bos

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
415: , BOM_RESOURCES br
416: WHERE NVL(br.disable_date, bos.effectivity_date + 1)
417: > bos.effectivity_date

Line 452: , BOM_OPERATION_SEQUENCES bos

448: FROM DUAL
449: WHERE NOT EXISTS(
450: SELECT NULL
451: FROM bom_operational_routings bor
452: , BOM_OPERATION_SEQUENCES bos
453: , CST_ACTIVITIES ca
454: WHERE bor.organization_id =
455: NVL(ca.organization_id, bor.organization_id)
456: AND NVL(TRUNC(ca.disable_date), TRUNC(bos.effectivity_date) + 1)

Line 682: , BOM_OPERATION_SEQUENCES bos

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
686: AND bos.acd_type = l_ACD_CHANGE

Line 757: , BOM_OPERATION_SEQUENCES bos

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
761: AND bor.schedule_seq_num = p_sch_seq_num

Line 793: , BOM_OPERATION_SEQUENCES bos

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
797: AND bor.schedule_seq_num = p_sch_seq_num

Line 918: , BOM_OPERATION_SEQUENCES bos

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
922: AND bos.acd_type = l_ACD_CHANGE

Line 966: FROM BOM_OPERATION_SEQUENCES bos

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
969: AND bd.department_id = bos.department_id
970: AND bos.operation_sequence_id = p_op_seq_id

Line 1138: , BOM_OPERATION_SEQUENCES bos

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
1142: AND bor.operation_sequence_id = bos.old_operation_sequence_id

Line 1468: FROM BOM_OPERATION_SEQUENCES

1464: -- Get ref flag and operation type
1465: CURSOR l_event_cur (p_op_seq_id NUMBER)
1466: IS
1467: SELECT reference_flag
1468: FROM BOM_OPERATION_SEQUENCES
1469: WHERE operation_sequence_id = p_op_seq_id ;
1470:
1471: l_event_rec l_event_cur%ROWTYPE ;
1472:

Line 2094: FROM BOM_OPERATION_SEQUENCES bos

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
2097: AND bor.operation_sequence_id = bos.old_operation_sequence_id
2098: AND bos.operation_sequence_id = p_op_seq_id

Line 2127: , BOM_OPERATION_SEQUENCES bos

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
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

Line 2133: , BOM_OPERATION_SEQUENCES bos

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
2137: AND bos.operation_sequence_id = p_op_seq_id ) ;

Line 2160: , BOM_OPERATION_SEQUENCES bos

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
2162: AND bsor.substitute_group_num = p_sub_group_num
2163: AND bsor.operation_sequence_id = bos.old_operation_sequence_id
2164: AND bos.operation_sequence_id = p_op_seq_id ) ;

Line 2190: , BOM_OPERATION_SEQUENCES bos

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
2192: AND bsor.substitute_group_num = p_sub_group_num
2193: AND bsor.operation_sequence_id = bos.old_operation_sequence_id
2194: AND bos.operation_sequence_id = p_op_seq_id ) ;