VIEW: APPS.RG_DSS_REQUESTS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)