Wednesday 28 March 2012

Function to get Fixed Assets Location by passing location id as parameter

CREATE OR REPLACE FUNCTION getFAloc(p1 IN NUMBER) RETURN VARCHAR2 AS
  v_loc VARCHAR2(500);
BEGIN
  SELECT A.SEGMENT1 || '.' || A.SEGMENT2 || '.' || A.SEGMENT3 || '.' ||
         A.SEGMENT4 || '.' || A.SEGMENT5
    INTO v_loc
    FROM fa_locations A
   WHERE location_id = p1;
  RETURN v_loc;
END;
/

No comments:

Post a Comment