DBA Data[Home] [Help]

APPS.BOM_VALIDATE_COMP_OPERATION dependencies on BOM_OPERATION_SEQUENCES

Line 540: FROM bom_operation_sequences bos

536: l_err_text VARCHAR2(240);
537:
538: CURSOR OpSeq_In_Original IS
539: SELECT operation_seq_num
540: FROM bom_operation_sequences bos
541: WHERE routing_sequence_id =
542: (SELECT common_routing_sequence_id
543: FROM bom_operational_routings bor
544: WHERE assembly_item_id = p_bom_comp_ops_unexp_rec.assembly_item_id

Line 553: FROM bom_operation_sequences bos

549: and nvl(trunc(disable_date), trunc(sysdate)+1) > trunc(sysdate) and nvl(operation_type,1) = 1;
550:
551: CURSOR Opseq_In_Primary IS
552: SELECT operation_seq_num
553: FROM bom_operation_sequences bos
554: WHERE routing_sequence_id =
555: (SELECT common_routing_sequence_id
556: FROM bom_operational_routings bor
557: WHERE assembly_item_id = p_bom_comp_ops_unexp_rec.assembly_item_id