View: RG_DSS_REQUESTS_V

Product:	RG - Application Report Generator
Description:
Implementation/DBA Data:	APPS.RG_DSS_REQUESTS_V

View Text

SELECT RR.PROGRAM_TYPE
, LK1.MEANING PROGRAM_NAME
, RR.REQUEST_ID
, RR.CONCURRENT_REQUEST_ID
, RR.STATUS_FLAG
, RR.FILE_SPEC
, RR.EXTRACTION_START_DATE
, RR.EXTRACTION_END_DATE
, RR.LOAD_START_DATE
, RR.LOAD_END_DATE
, RR.CHART_OF_ACCOUNTS_ID
, FS.ID_FLEX_STRUCTURE_NAME CHART_OF_ACCOUNTS_NAME
, RR.LEDGER_ID
, LG.NAME LEDGER_NAME
, RR.FROM_PERIOD
, RR.TO_PERIOD
, RR.BALANCE_TYPE
, LK2.MEANING BALANCE_MEANING
, RR.BUDGET_VERSION_ID
, RR.ENCUMBRANCE_TYPE_ID
, DECODE(RR.BALANCE_TYPE
, 'B'
, GB.BUDGET_NAME
, 'C'
, GB.BUDGET_NAME
, 'E'
, ET.ENCUMBRANCE_TYPE
, NULL) BUDGET_ENC_NAME
, RR.TEMPLATE_ID
, ST.TEMPLATE_NAME
, RR.DAY_OF_PERIOD
, RR.HIERARCHY_ID
, RH.NAME HIERARCHY_NAME
, RR.PERIOD_YEAR
, RR.LAST_UPDATE_DATE
, RR.LAST_UPDATED_BY
, RR.LAST_UPDATE_LOGIN
, RR.CREATION_DATE
, RR.CREATED_BY
FROM RG_DSS_REQUESTS RR
, GL_LOOKUPS LK1
, GL_LOOKUPS LK2
, FND_ID_FLEX_STRUCTURES_TL FS
, GL_LEDGERS LG
, GL_BUDGET_VERSIONS GB
, RG_DSS_HIERARCHIES RH
, GL_ENCUMBRANCE_TYPES ET
, GL_SUMMARY_TEMPLATES ST
WHERE RR.CHART_OF_ACCOUNTS_ID = FS.ID_FLEX_NUM(+)
AND FS.APPLICATION_ID(+) = 101
AND FS.ID_FLEX_CODE(+) = 'GL#'
AND FS.LANGUAGE(+) = USERENV('LANG')
AND RR.LEDGER_ID = LG.LEDGER_ID(+)
AND RR.BUDGET_VERSION_ID = GB.BUDGET_VERSION_ID(+)
AND RR.ENCUMBRANCE_TYPE_ID = ET.ENCUMBRANCE_TYPE_ID(+)
AND RR.HIERARCHY_ID = RH.HIERARCHY_ID(+)
AND LK1.LOOKUP_TYPE = 'GL_DSS_PROGRAM_TYPE'
AND RR.PROGRAM_TYPE||'' = LK1.LOOKUP_CODE
AND LK2.LOOKUP_TYPE(+) = 'GL_DSS_BALANCE_TYPE'
AND RR.BALANCE_TYPE||'' = LK2.LOOKUP_CODE(+)
AND RR.TEMPLATE_ID = ST.TEMPLATE_ID(+)

Columns