[Home] [Help] [Dependency Information]
Object Name: | IBE_BI_CAT_TIME_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.IBE_BI_CAT_TIME_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBE_BI_CAT_TIME_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
PERIOD_TYPE_ID MINISITE_ID |
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 does not reference any database object
APPS.IBE_BI_CAT_TIME_MV is referenced by following:
|
|
|