DBA Data[Home] [Help]

APPS.BOM_VALIDATE_RTG_REVISION dependencies on BOM_OPERATIONAL_ROUTINGS

Line 338: FROM bom_operational_routings

334: --
335: BEGIN
336: SELECT routing_sequence_id
337: INTO l_dummy
338: FROM bom_operational_routings
339: WHERE assembly_item_id = p_rtg_rev_Unexp_Rec.assembly_item_id
340: AND organization_id = p_rtg_rev_Unexp_Rec.organization_id
341: AND ((alternate_routing_designator is null and p_rtg_revision_rec.alternate_routing_code is null) --modified for 12558505
342: or (alternate_routing_designator = p_rtg_revision_rec.alternate_routing_code));