DBA Data[Home] [Help]

APPS.BOM_RTG_EXP dependencies on BOM_OPERATION_SEQUENCES

Line 477: FROM bom_operation_sequences_v

473: Attribute14,
474: Attribute15,
475: Original_System_Reference
476: --,long_description
477: FROM bom_operation_sequences_v
478: WHERE routing_sequence_id = P_routing_seq_id;
479: i NUMBER := 1;
480: l_op_seq_id NUMBER;
481: l_op_seq_num NUMBER;

Line 595: bom_operation_sequences bos1,

591: bonv.Attribute14,
592: bonv.Attribute15,
593: bonv.Original_System_Reference
594: FROM bom_operation_networks_v bonv,
595: bom_operation_sequences bos1,
596: bom_operation_sequences bos2
597: WHERE bonv.routing_sequence_id = P_routing_seq_id
598: AND bos1.Operation_Sequence_Id = bonv.From_Op_Seq_Id
599: AND bos2.Operation_Sequence_Id = bonv.To_Op_Seq_Id;

Line 596: bom_operation_sequences bos2

592: bonv.Attribute15,
593: bonv.Original_System_Reference
594: FROM bom_operation_networks_v bonv,
595: bom_operation_sequences bos1,
596: bom_operation_sequences bos2
597: WHERE bonv.routing_sequence_id = P_routing_seq_id
598: AND bos1.Operation_Sequence_Id = bonv.From_Op_Seq_Id
599: AND bos2.Operation_Sequence_Id = bonv.To_Op_Seq_Id;
600: i NUMBER := 1;