VIEW: APPS.JG_ZZ_SRS_LEDGER_BUD_ENCUM_V

Source

View Text - Preformatted

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 ALL 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 ALL 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'

View Text - HTML Formatted

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 ALL 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 ALL 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'