APPS.BOM_SUB_RESOURCES_PKG dependencies on BOM_OPERATION_SEQUENCES

Line 761: FROM bom_operation_sequences

757: to_op_seq_num NUMBER;
758: BEGIN
759: SELECT operation_seq_num
760: INTO from_op_seq_num
761: FROM bom_operation_sequences
762: WHERE operation_sequence_id = x_from_op_seq_id;
763:
764: SELECT operation_seq_num
765: INTO to_op_seq_num

Line 766: FROM bom_operation_sequences

762: WHERE operation_sequence_id = x_from_op_seq_id;
763:
764: SELECT operation_seq_num
765: INTO to_op_seq_num
766: FROM bom_operation_sequences
767: WHERE operation_sequence_id = x_to_op_seq_id;
768:
769: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
770: (SELECT 1 FROM BOM_OPERATION_NETWORKS

Line 823: FROM bom_operation_sequences

819: x_operation_seq_num OUT NOCOPY NUMBER) IS
820:
821: CURSOR operations (p_rtg_seq_id NUMBER)IS
822: SELECT operation_seq_num, operation_sequence_id
823: FROM bom_operation_sequences
824: WHERE routing_sequence_id = p_rtg_seq_id;
825:
826: /*Fix for bug 6074930 - Added schedule_flag <> 2 conditions in the queries below.
827: This is done to filter off unscheduled resources, sub-resources. */

Line 838: bom_operation_sequences bos ,

834: bor.schedule_seq_num,
835: bor.substitute_group_num,
836: bor.schedule_flag
837: FROM bom_operation_resources bor ,
838: bom_operation_sequences bos ,
839: bom_resources br ,
840: bom_department_resources bdr ,
841: cst_activities ca ,
842: bom_setup_types bst

Line 882: bom_operation_sequences bos ,

878: bor.schedule_seq_num,
879: bor.substitute_group_num,
880: bor.schedule_flag
881: FROM bom_sub_operation_resources bor ,
882: bom_operation_sequences bos ,
883: bom_resources br ,
884: bom_department_resources bdr ,
885: cst_activities ca ,
886: bom_setup_types bst