APPS.EAM_ACTIVITYUTILITIES_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1022: FROM bom_operational_routings

1018: THEN
1019: RETURN NULL;
1020: ELSE
1021: SELECT routing_sequence_id INTO l_rtg_sequence_id
1022: FROM bom_operational_routings
1023: WHERE organization_id = p_organization_id
1024: AND assembly_item_id = p_assembly_item_id
1025: AND ( (alternate_routing_designator IS NULL AND p_alternate_rtg_designator IS NULL)
1026: OR alternate_routing_designator = p_alternate_rtg_designator);

Line 1646: from bom_operational_routings

1642: return boolean is
1643: l_count number;
1644: begin
1645: select count(1) into l_count
1646: from bom_operational_routings
1647: where assembly_item_id = p_inventory_item_id and
1648: organization_id = p_org_id;
1649:
1650: if l_count > 0 then