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

VIEW: IBE.IBE_ECR_MVLOG#

Object Details
Object Name: IBE_ECR_MVLOG#
Object Type: VIEW
Owner: IBE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MVLOG_ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

SECURITY_GROUP_ID NUMBER (15)
REQUEST_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REFRESH_MODE VARCHAR2 (30)
MVIEW_NAME VARCHAR2 (240) Yes
REFRESH_STATUS NUMBER
Yes
BEGIN_DATE DATE
Yes
END_DATE DATE
Yes
CURRENCY_CODE VARCHAR2 (240)
CONVERSION_TYPE VARCHAR2 (30)
FACT_SOURCE VARCHAR2 (2000)
ERROR_CODE VARCHAR2 (80)
ERROR_MESSAGE VARCHAR2 (2000)
REFRESH_DURATION NUMBER

DAY_BIN_OFFSET NUMBER

FORCE_REFRESH_FLAG VARCHAR2 (3)
QUARTER_BEGIN_FLAG VARCHAR2 (3)
PERIOD_SET_NAME VARCHAR2 (15)
Query Text

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


SELECT MVLOG_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      REFRESH_MODE
,      MVIEW_NAME
,      REFRESH_STATUS
,      BEGIN_DATE
,      END_DATE
,      CURRENCY_CODE
,      CONVERSION_TYPE
,      FACT_SOURCE
,      ERROR_CODE
,      ERROR_MESSAGE
,      REFRESH_DURATION
,      DAY_BIN_OFFSET
,      FORCE_REFRESH_FLAG
,      QUARTER_BEGIN_FLAG
,      PERIOD_SET_NAME
FROM IBE.IBE_ECR_MVLOG#;

Dependencies

[top of page]

IBE.IBE_ECR_MVLOG# references the following:

SchemaIBE
TableIBE_ECR_MVLOG
IBE.IBE_ECR_MVLOG# is referenced by following:

SchemaAPPS
SynonymIBE_ECR_MVLOG