[Home] [Help] [Dependency Information]
Object Name: | IBE_BI_CAT_TIME_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | IBE_BI_CAT_TIME_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | TEXTMATCH |
Refresh Mode: | DEMAND |
Refresh Method: | FORCE |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
FII_TIME_DAY
IBE_BI_CART_ORD_MV
FII_TIME_DAY
IBE_BI_CARTS_MV
ASO_BI_QUOTE_LINES_ALL
IBE_BI_ORDERS_MV
IBE_BI_ORDERBOM_MV
IBE_BI_CARTS_MV
ASO_BI_QUOTE_LINES_ALL
ISC_BOOK_SUM2_F
IBE_BI_CAT_MV
ASO_BI_QUOTE_LINES_ALL
ENI_DENORM_HIERARCHIES
ENI_OLTP_ITEM_STAR
IBE_BI_ORDERBOM_MV
IBE_BI_CARTS_MV
ASO_BI_QUOTE_LINES_ALL
ISC_BOOK_SUM2_F
MTL_DEFAULT_CATEGORY_SETS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UMAR | NUMBER | |||
TIME_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
MINISITE_ID | NUMBER | |||
UMARK | VARCHAR2 | (7) | ||
UMARKER | VARCHAR2 | (10) | ||
CATID | NUMBER | |||
PARENT_CATEGORY_ID | NUMBER | |||
TOP_NODE_FLAG | VARCHAR2 | (1) | ||
LEAF_NODE | VARCHAR2 | (1) | ||
ASSIST_FLAG | VARCHAR2 | (1) | ||
CURR_F | VARCHAR2 | (30) | ||
ORD_COUNT | NUMBER | |||
CON_ORD | NUMBER | |||
ORD_AMT_G | NUMBER | |||
ORD_AMT_G1 | NUMBER | |||
ORD_AMT_F | NUMBER | |||
ORD_LIST_G | NUMBER | |||
ORD_LIST_G1 | NUMBER | |||
ORD_LIST_F | NUMBER | |||
ORD_DISC_G | NUMBER | |||
ORD_DISC_G1 | NUMBER | |||
ORD_DISC_F | NUMBER | |||
CART_COUNT | NUMBER | |||
CART_AMT_G | NUMBER | |||
CART_AMT_G1 | NUMBER | |||
CART_AMT_F | NUMBER | |||
T_ORD_COUNT | NUMBER | |||
T_CON_ORD | NUMBER | |||
T_ORD_AMT_G | NUMBER | |||
T_ORD_AMT_G1 | NUMBER | |||
T_ORD_AMT_F | NUMBER | |||
T_ORD_LIST_G | NUMBER | |||
T_ORD_LIST_G1 | NUMBER | |||
T_ORD_LIST_F | NUMBER | |||
T_ORD_DISC_G | NUMBER | |||
T_ORD_DISC_G1 | NUMBER | |||
T_ORD_DISC_F | NUMBER | |||
T_CART_COUNT | NUMBER | |||
T_CART_AMT_G | NUMBER | |||
T_CART_AMT_G1 | NUMBER | |||
T_CART_AMT_F | NUMBER | |||
ENT_YEAR_ID | NUMBER | |||
ENT_QTR_ID | NUMBER | |||
ENT_PERIOD_ID | NUMBER | |||
WEEK_ID | NUMBER | |||
REPORT_DATE_JULIAN | NUMBER | |||
D_ORD_AMT_G_CNT | NUMBER | |||
D_ORD_AMT_G1_CNT | NUMBER | |||
D_ORD_AMT_F_CNT | NUMBER | |||
D_ORD_LIST_G_CNT | NUMBER | |||
D_ORD_LIST_G1_CNT | NUMBER | |||
D_ORD_LIST_F_CNT | NUMBER | |||
D_ORD_DISC_G_CNT | NUMBER | |||
D_ORD_DISC_G1_CNT | NUMBER | |||
D_ORD_DISC_F_CNT | NUMBER | |||
D_CART_AMT_G_CNT | NUMBER | |||
D_CART_AMT_G1_CNT | NUMBER | |||
D_CART_AMT_F_CNT | NUMBER | |||
D_CON_ORD | NUMBER | |||
D_CART_COUNT | NUMBER | |||
D_GID | NUMBER | |||
D_TOTAL_CNT | NUMBER | |||
D_ORD_COUNT | NUMBER | |||
D_ORD_AMT_G | NUMBER | |||
D_ORD_AMT_G1 | NUMBER | |||
D_ORD_AMT_F | NUMBER | |||
D_ORD_DISC_G | NUMBER | |||
D_ORD_DISC_G1 | NUMBER | |||
D_ORD_DISC_F | NUMBER | |||
D_ORD_LIST_G | NUMBER | |||
D_ORD_LIST_G1 | NUMBER | |||
D_ORD_LIST_F | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT UMAR
, TIME_ID
, PERIOD_TYPE_ID
, MINISITE_ID
, UMARK
, UMARKER
, CATID
, PARENT_CATEGORY_ID
, TOP_NODE_FLAG
, LEAF_NODE
, ASSIST_FLAG
, CURR_F
, ORD_COUNT
, CON_ORD
, ORD_AMT_G
, ORD_AMT_G1
, ORD_AMT_F
, ORD_LIST_G
, ORD_LIST_G1
, ORD_LIST_F
, ORD_DISC_G
, ORD_DISC_G1
, ORD_DISC_F
, CART_COUNT
, CART_AMT_G
, CART_AMT_G1
, CART_AMT_F
, T_ORD_COUNT
, T_CON_ORD
, T_ORD_AMT_G
, T_ORD_AMT_G1
, T_ORD_AMT_F
, T_ORD_LIST_G
, T_ORD_LIST_G1
, T_ORD_LIST_F
, T_ORD_DISC_G
, T_ORD_DISC_G1
, T_ORD_DISC_F
, T_CART_COUNT
, T_CART_AMT_G
, T_CART_AMT_G1
, T_CART_AMT_F
, ENT_YEAR_ID
, ENT_QTR_ID
, ENT_PERIOD_ID
, WEEK_ID
, REPORT_DATE_JULIAN
, D_ORD_AMT_G_CNT
, D_ORD_AMT_G1_CNT
, D_ORD_AMT_F_CNT
, D_ORD_LIST_G_CNT
, D_ORD_LIST_G1_CNT
, D_ORD_LIST_F_CNT
, D_ORD_DISC_G_CNT
, D_ORD_DISC_G1_CNT
, D_ORD_DISC_F_CNT
, D_CART_AMT_G_CNT
, D_CART_AMT_G1_CNT
, D_CART_AMT_F_CNT
, D_CON_ORD
, D_CART_COUNT
, D_GID
, D_TOTAL_CNT
, D_ORD_COUNT
, D_ORD_AMT_G
, D_ORD_AMT_G1
, D_ORD_AMT_F
, D_ORD_DISC_G
, D_ORD_DISC_G1
, D_ORD_DISC_F
, D_ORD_LIST_G
, D_ORD_LIST_G1
, D_ORD_LIST_F
FROM APPS.IBE_BI_CAT_TIME_MV;
APPS.IBE_BI_CAT_TIME_MV is not referenced by any database object
|
|
|