DBA Data[Home] [Help] [Dependency Information]

VIEW: RG.RG_DSS_REQUESTS#

Object Details
Object Name: RG_DSS_REQUESTS#
Object Type: VIEW
Owner: RG
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROGRAM_TYPE VARCHAR2 (1) Yes
REQUEST_ID NUMBER (15) Yes
CONCURRENT_REQUEST_ID NUMBER (15) Yes
STATUS_FLAG VARCHAR2 (1) Yes
LEVEL_CODE VARCHAR2 (1)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
FILE_SPEC VARCHAR2 (240)
EXTRACTION_START_DATE DATE

EXTRACTION_END_DATE DATE

LOAD_START_DATE DATE

LOAD_END_DATE DATE

CHART_OF_ACCOUNTS_ID NUMBER (15)
LEDGER_ID NUMBER (15)
FROM_PERIOD VARCHAR2 (15)
TO_PERIOD VARCHAR2 (15)
BALANCE_TYPE VARCHAR2 (4)
BUDGET_VERSION_ID NUMBER (15)
ENCUMBRANCE_TYPE_ID NUMBER (15)
TEMPLATE_ID NUMBER (15)
DAY_OF_PERIOD NUMBER (15)
HIERARCHY_ID NUMBER (15)
PERIOD_YEAR NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

RG.RG_DSS_REQUESTS# references the following:

SchemaRG
TableRG_DSS_REQUESTS
RG.RG_DSS_REQUESTS# is referenced by following:

SchemaAPPS
SynonymRG_DSS_REQUESTS