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

VIEW: GL.GL_EFC_RUN_HISTORY#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
NCU_SET_OF_BOOKS_ID NUMBER (15) Yes
EURO_SET_OF_BOOKS_ID NUMBER (15) Yes
APPLICATION_ID NUMBER (15) Yes
TABLE_NAME VARCHAR2 (30) Yes
RUN_PHASE_CODE VARCHAR2 (15) Yes
RUN_ID NUMBER (15) Yes
RUN_STATUS_CODE VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
START_PK_ID NUMBER (15)
LAST_PROCESSED_PK_ID NUMBER (15)
MAX_PK_ID NUMBER (15)
ERROR_MESSAGE_NAME VARCHAR2 (30)
ERROR_TOKEN1 VARCHAR2 (80)
ERROR_TOKEN2 VARCHAR2 (80)
ERROR_TOKEN3 VARCHAR2 (80)
ORA_ERROR VARCHAR2 (2000)
REFERENCE1 VARCHAR2 (100)
REFERENCE2 VARCHAR2 (100)
REFERENCE3 VARCHAR2 (100)
REFERENCE4 VARCHAR2 (100)
REFERENCE5 VARCHAR2 (100)
Query Text

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


SELECT NCU_SET_OF_BOOKS_ID
,      EURO_SET_OF_BOOKS_ID
,      APPLICATION_ID
,      TABLE_NAME
,      RUN_PHASE_CODE
,      RUN_ID
,      RUN_STATUS_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      START_PK_ID
,      LAST_PROCESSED_PK_ID
,      MAX_PK_ID
,      ERROR_MESSAGE_NAME
,      ERROR_TOKEN1
,      ERROR_TOKEN2
,      ERROR_TOKEN3
,      ORA_ERROR
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
FROM GL.GL_EFC_RUN_HISTORY#;

Dependencies

[top of page]

GL.GL_EFC_RUN_HISTORY# references the following:

SchemaGL
TableGL_EFC_RUN_HISTORY
GL.GL_EFC_RUN_HISTORY# is referenced by following:

SchemaAPPS
SynonymGL_EFC_RUN_HISTORY