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

VIEW: GL.GL_OASIS_SUMMARY_DATA#

Object Details
Object Name: GL_OASIS_SUMMARY_DATA#
Object Type: VIEW
Owner: GL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes
FIN_ITEM_ID VARCHAR2 (7) Yes
DRILLDOWN_SEGNUM1 NUMBER (15) Yes
DRILLDOWN_SEGNUM2 NUMBER (15) Yes
ACTUAL_FLAG VARCHAR2 (1) Yes
DRILLDOWN_SEGVAL1 VARCHAR2 (25) Yes
DRILLDOWN_SEGVAL2 VARCHAR2 (25) Yes
RELATIVE_PERIOD_POS NUMBER (15) Yes
PERIOD_NAME VARCHAR2 (15) Yes
PERIOD_NUM NUMBER (15) Yes
PERIOD_YEAR NUMBER (15) Yes
QUARTER_NUM NUMBER (15) Yes
DRILLDOWN_SEGDESC1 VARCHAR2 (240)
DRILLDOWN_SEGDESC2 VARCHAR2 (240)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
PERIOD_TO_DATE NUMBER (15)
QUARTER_TO_DATE NUMBER (15)
YEAR_TO_DATE NUMBER (15)
Query Text

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


SELECT SET_OF_BOOKS_ID
,      FIN_ITEM_ID
,      DRILLDOWN_SEGNUM1
,      DRILLDOWN_SEGNUM2
,      ACTUAL_FLAG
,      DRILLDOWN_SEGVAL1
,      DRILLDOWN_SEGVAL2
,      RELATIVE_PERIOD_POS
,      PERIOD_NAME
,      PERIOD_NUM
,      PERIOD_YEAR
,      QUARTER_NUM
,      DRILLDOWN_SEGDESC1
,      DRILLDOWN_SEGDESC2
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PERIOD_TO_DATE
,      QUARTER_TO_DATE
,      YEAR_TO_DATE
FROM GL.GL_OASIS_SUMMARY_DATA#;

Dependencies

[top of page]

GL.GL_OASIS_SUMMARY_DATA# references the following:

SchemaGL
TableGL_OASIS_SUMMARY_DATA
GL.GL_OASIS_SUMMARY_DATA# is referenced by following:

SchemaAPPS
SynonymGL_OASIS_SUMMARY_DATA