[Home] [Help] [Dependency Information]
Object Name: | BIM_I_ORD_INT_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | BIM_I_ORD_INT_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
BIM_I_ORD_COL_MV
BIM_I_SOURCE_CODES
ENI_OLTP_ITEM_STAR
ISC_BOOK_SUM2_F
ENI_DENORM_HIERARCHIES
MTL_DEFAULT_CATEGORY_SETS
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 | |||
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 | |||
CATEGORY_FLAG | CHAR | (1) | ||
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 |
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
, METRIC_TYPE
, CHILD_OBJECT_ID
, CHILD_OBJECT_TYPE
, OBJECT_REGION
, OBJECT_COUNTRY
, OBJECT_STATUS
, ACTIVITY_ID
, CATEGORY_FLAG
, 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_INT_MV;
|
|
|