View: RG_SRS_DSS_BUD_ENC_V

Product:	RG - Application Report Generator
Description:	10SC ONLY
Implementation/DBA Data:	APPS.RG_SRS_DSS_BUD_ENC_V

View Text

SELECT MEANING BUDGET_ENCUMBRANCE_NAME
, -100 BUDGET_ENCUMBRANCE_ID
, -1 LEDGER_ID
, -1 SYSTEM_ID
, 'A' ACTUAL_FLAG
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'N/A' UNION SELECT DISTINCT GLBV.BUDGET_NAME BUDGET_ENCUMBRANCE_NAME
, GLBV.BUDGET_VERSION_ID BUDGET_ENCUMBRANCE_ID
, VAR.LEDGER_ID LEDGER_ID
, SV.SYSTEM_ID SYSTEM_ID
, 'B' ACTUAL_FLAG
FROM GL_BUDGET_VERSIONS GLBV
, RG_DSS_VARIABLES VAR
, RG_DSS_SYSTEM_VARIABLES SV
WHERE VAR.VARIABLE_ID = SV.VARIABLE_ID + 0
AND VAR.BALANCE_TYPE = 'B'
AND GLBV.BUDGET_VERSION_ID = VAR.BUDGET_VERSION_ID UNION SELECT DISTINCT DECODE(VAR.ENCUMBRANCE_TYPE_ID
, -1
, L.MEANING
, GLET.ENCUMBRANCE_TYPE) BUDGET_ENCUMBRANCE_NAME
, VAR.ENCUMBRANCE_TYPE_ID BUDGET_ENCUMBRANCE_ID
, VAR.LEDGER_ID LEDGER_ID
, SV.SYSTEM_ID SYSTEM_ID
, 'E' ACTUAL_FLAG
FROM GL_ENCUMBRANCE_TYPES GLET
, GL_LOOKUPS L
, RG_DSS_VARIABLES VAR
, RG_DSS_SYSTEM_VARIABLES SV
WHERE VAR.VARIABLE_ID = SV.VARIABLE_ID + 0
AND VAR.BALANCE_TYPE = 'E'
AND GLET.ENCUMBRANCE_TYPE_ID(+) = VAR.ENCUMBRANCE_TYPE_ID
AND L.LOOKUP_TYPE = 'GL_DSS_ENCUMBRANCE_TYPE'
AND L.LOOKUP_CODE = 'TOTAL' UNION SELECT L.MEANING BUDGET_ENCUMBRANCE_NAME
, -2 BUDGET_ENCUMBRANCE_ID
, -1 LEDGER_ID
, -1 SYSTEM_ID
, 'E' ACTUAL_FLAG
FROM GL_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'GL_DSS_ENCUMBRANCE_TYPE'
AND L.LOOKUP_CODE = 'ALL'

Columns