View: GL_SRS_LEDGER_BUD_ENCUM_NAME

Product:	GL - General Ledger
Description:	Review budget names and encumbrance types
Implementation/DBA Data:	APPS.GL_SRS_LEDGER_BUD_ENCUM_NAME

View Text

SELECT MEANING BUDGET_ENCUMBRANCE_NAME
, -100 BUDGET_ENCUMBRANCE_ID
, 'ACTUAL' LEDGER_ID
, 'A' ACTUAL_FLAG
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'N/A' UNION SELECT GLBV.BUDGET_NAME BUDGET_ENCUMBRANCE_NAME
, GLBV.BUDGET_VERSION_ID BUDGET_ENCUMBRANCE_ID
, TO_CHAR(GLB.LEDGER_ID) LEDGER_ID
, 'B' ACTUAL_FLAG FROM GL_BUDGETS GLB
, GL_BUDGET_VERSIONS GLBV WHERE GLBV.BUDGET_NAME = GLB.BUDGET_NAME AND GLBV.BUDGET_VERSION_ID IN ( SELECT DISTINCT BUDGET_VERSION_ID
FROM GL_BUDGET_PERIOD_RANGES ) UNION SELECT GLET.ENCUMBRANCE_TYPE BUDGET_ENCUMBRANCE_NAME
, GLET.ENCUMBRANCE_TYPE_ID BUDGET_ENCUMBRANCE_ID
, 'ENCUMBRANCE' LEDGER_ID
, 'E' ACTUAL_FLAG
FROM GL_ENCUMBRANCE_TYPES GLET
WHERE ENABLED_FLAG = 'Y'

Columns