DBA Data[Home] [Help]

APPS.BOM_VALIDATE_COMP_OPERATION dependencies on BOM_OPERATIONAL_ROUTINGS

Line 545: FROM bom_operational_routings bor

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

Line 558: FROM bom_operational_routings bor

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