DBA Data[Home] [Help]

APPS.BOM_VALIDATE_COMP_OPERATION dependencies on BOM_OPERATIONAL_ROUTINGS

Line 543: FROM bom_operational_routings bor

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
545: and organization_id = p_bom_comp_ops_unexp_rec.organization_id
546: and nvl(alternate_routing_designator,'NONE') =
547: nvl(p_bom_comp_ops_rec.alternate_bom_code, 'NONE')

Line 556: FROM bom_operational_routings bor

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
558: and organization_id = p_bom_comp_ops_unexp_rec.organization_id
559: and alternate_routing_designator IS NULL
560: )