DBA Data[Home] [Help]

APPS.BOM_VALIDATE_COMP_OPERATION dependencies on BOM_OPERATION_SEQUENCES

Line 542: FROM bom_operation_sequences bos

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

Line 555: FROM bom_operation_sequences bos

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