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

MATERIALIZED VIEW: APPS.BIM_I_ORD_COL_MV

Object Details
Object Name: BIM_I_ORD_COL_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: BIM_I_ORD_COL_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

BIM_I_SOURCE_CODES
ENI_OLTP_ITEM_STAR
ISC_BOOK_SUM2_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
UMARK NUMBER

TRANSACTION_CREATE_DATE DATE

SOURCE_CODE_ID NUMBER

OBJECT_ID NUMBER

OBJECT_TYPE VARCHAR2 (30)
VBH_CATEGORY_ID NUMBER

PRIMARY_CATEGORY_ID NUMBER

METRIC_TYPE CHAR (5)
CHILD_OBJECT_ID NUMBER

CHILD_OBJECT_TYPE VARCHAR2 (30)
OBJECT_REGION VARCHAR2 (30)
OBJECT_COUNTRY VARCHAR2 (30)
OBJECT_STATUS VARCHAR2 (30)
ACTIVITY_ID NUMBER

BOOKED_AMT_F NUMBER

BOOKED_AMT_F_C NUMBER

INVOICED_AMT_F NUMBER

INVOICED_AMT_F_C NUMBER

BOOKED_AMT_S NUMBER

BOOKED_AMT_S_C NUMBER

INVOICED_AMT_S NUMBER

INVOICED_AMT_S_C NUMBER

ALL_C NUMBER

Query Text

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


SELECT UMARK
,      TRANSACTION_CREATE_DATE
,      SOURCE_CODE_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      VBH_CATEGORY_ID
,      PRIMARY_CATEGORY_ID
,      METRIC_TYPE
,      CHILD_OBJECT_ID
,      CHILD_OBJECT_TYPE
,      OBJECT_REGION
,      OBJECT_COUNTRY
,      OBJECT_STATUS
,      ACTIVITY_ID
,      BOOKED_AMT_F
,      BOOKED_AMT_F_C
,      INVOICED_AMT_F
,      INVOICED_AMT_F_C
,      BOOKED_AMT_S
,      BOOKED_AMT_S_C
,      INVOICED_AMT_S
,      INVOICED_AMT_S_C
,      ALL_C
FROM APPS.BIM_I_ORD_COL_MV;

Dependencies

[top of page]

APPS.BIM_I_ORD_COL_MV references the following:

SchemaAPPS
TableBIM_I_ORD_COL_MV
SchemaBIM
TableBIM_I_SOURCE_CODES
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaISC
TableISC_BOOK_SUM2_F
APPS.BIM_I_ORD_COL_MV is referenced by following:

SchemaAPPS
Materialized ViewBIM_I_EXT_COL_MV
Materialized ViewBIM_I_ORD_INT_MV