SELECT ENCUMBRANCE_TYPE_ID, ENCUMBRANCE_TYPE, DESCRIPTION FROM GL_ENCUMBRANCE_TYPES WHERE ENABLED_FLAG = 'Y' UNION ALL SELECT -1 , MEANING, DESCRIPTION FROM GL_LOOKUPS WHERE LOOKUP_TYPE = 'LITERAL' AND LOOKUP_CODE = 'ALL'
SELECT ENCUMBRANCE_TYPE_ID
, ENCUMBRANCE_TYPE
, DESCRIPTION
FROM GL_ENCUMBRANCE_TYPES
WHERE ENABLED_FLAG = 'Y' UNION ALL SELECT -1
, MEANING
, DESCRIPTION
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'ALL'
|
|
|