f_get_flg_warranty_for_so_item

/**
 * Adrian, Nov 09, 2017
 * Untuk mendapatkan flag warranty so item
 */

CREATE OR REPLACE FUNCTION f_get_flg_warranty_for_so_item(bigint)
  RETURNS character varying AS
$BODY$
DECLARE
    pMasterId               alias for $1; --so_item_id

    vResult                 character varying(1);

BEGIN

    vResult := 'N';

    SELECT
        CASE WHEN COUNT(*) = 0 THEN
            'N'
        ELSE
            'Y'
        END
    INTO vResult
    FROM sl_so_warranty_item
    WHERE so_item_id = pMasterId;

    return vResult;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
  /