VIEW: APPS.RG_SRS_DSS_BUD_ENC_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'