[Home] [Help]
337: SELECT
338: DESCRIPTION
339: INTO L_DESC
340: FROM
341: MTL_DESCRIPTIVE_ELEMENTS
342: WHERE ITEM_CATALOG_GROUP_ID = L_CATALOG_GROUP_ID
343: AND ELEMENT_NAME = L_ELEMENT_NAME;
344: ELSIF L_ITEM_TYPE = 2 THEN
345: SELECT
345: SELECT
346: MIN(DESCRIPTION)
347: INTO L_DESC
348: FROM
349: MTL_DESCRIPTIVE_ELEMENTS
350: WHERE ELEMENT_NAME = L_ELEMENT_NAME;
351: END IF;
352: RETURN (L_DESC);
353: END GET_ELE_DESC;