VIEW: RG.RG_DSS_REQUESTS#

Source

View Text - Preformatted

select PROGRAM_TYPE PROGRAM_TYPE, REQUEST_ID REQUEST_ID, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID, STATUS_FLAG STATUS_FLAG, LEVEL_CODE LEVEL_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FILE_SPEC FILE_SPEC, EXTRACTION_START_DATE EXTRACTION_START_DATE, EXTRACTION_END_DATE EXTRACTION_END_DATE, LOAD_START_DATE LOAD_START_DATE, LOAD_END_DATE LOAD_END_DATE, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, LEDGER_ID LEDGER_ID, FROM_PERIOD FROM_PERIOD, TO_PERIOD TO_PERIOD, BALANCE_TYPE BALANCE_TYPE, BUDGET_VERSION_ID BUDGET_VERSION_ID, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, TEMPLATE_ID TEMPLATE_ID, DAY_OF_PERIOD DAY_OF_PERIOD, HIERARCHY_ID HIERARCHY_ID, PERIOD_YEAR PERIOD_YEAR from "RG"."RG_DSS_REQUESTS"

View Text - HTML Formatted

SELECT PROGRAM_TYPE PROGRAM_TYPE
, REQUEST_ID REQUEST_ID
, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID
, STATUS_FLAG STATUS_FLAG
, LEVEL_CODE LEVEL_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FILE_SPEC FILE_SPEC
, EXTRACTION_START_DATE EXTRACTION_START_DATE
, EXTRACTION_END_DATE EXTRACTION_END_DATE
, LOAD_START_DATE LOAD_START_DATE
, LOAD_END_DATE LOAD_END_DATE
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, LEDGER_ID LEDGER_ID
, FROM_PERIOD FROM_PERIOD
, TO_PERIOD TO_PERIOD
, BALANCE_TYPE BALANCE_TYPE
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, TEMPLATE_ID TEMPLATE_ID
, DAY_OF_PERIOD DAY_OF_PERIOD
, HIERARCHY_ID HIERARCHY_ID
, PERIOD_YEAR PERIOD_YEAR
FROM "RG"."RG_DSS_REQUESTS"