[Home] [Help] [Dependency Information]
Object Name: | OKI_SRM_003_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | OKI_SRM_003_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS
FII_TIME_DAY
OKI_DBI_CLE_B
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUTHORING_ORG_ID | NUMBER | Yes | ||
RESOURCE_ID | NUMBER | |||
RG_ID | NUMBER | |||
REN_TYPE | CHAR | (3) | ||
GRP_ID | NUMBER | |||
TIME_ID | NUMBER | |||
ENT_QTR_ID | NUMBER | |||
ENT_PERIOD_ID | NUMBER | |||
WEEK_ID | NUMBER | |||
DAY_ID | NUMBER | |||
BUCKET1_AMT_G | NUMBER | |||
BUCKET1_AMT_SG | NUMBER | |||
BUCKET1_AMT_F | NUMBER | |||
BUCKET2_AMT_G | NUMBER | |||
BUCKET2_AMT_SG | NUMBER | |||
BUCKET2_AMT_F | NUMBER | |||
BUCKET3_AMT_G | NUMBER | |||
BUCKET3_AMT_SG | NUMBER | |||
BUCKET3_AMT_F | NUMBER | |||
BUCKET4_AMT_G | NUMBER | |||
BUCKET4_AMT_SG | NUMBER | |||
BUCKET4_AMT_F | NUMBER | |||
BUCKET5_AMT_G | NUMBER | |||
BUCKET5_AMT_SG | NUMBER | |||
BUCKET5_AMT_F | NUMBER | |||
BUCKET6_AMT_G | NUMBER | |||
BUCKET6_AMT_SG | NUMBER | |||
BUCKET6_AMT_F | NUMBER | |||
BUCKET7_AMT_G | NUMBER | |||
BUCKET7_AMT_SG | NUMBER | |||
BUCKET7_AMT_F | NUMBER | |||
BUCKET8_AMT_G | NUMBER | |||
BUCKET8_AMT_SG | NUMBER | |||
BUCKET8_AMT_F | NUMBER | |||
BUCKET9_AMT_G | NUMBER | |||
BUCKET9_AMT_SG | NUMBER | |||
BUCKET9_AMT_F | NUMBER | |||
BUCKET10_AMT_G | NUMBER | |||
BUCKET10_AMT_SG | NUMBER | |||
BUCKET10_AMT_F | NUMBER | |||
BUCKET1_CNT_G | NUMBER | |||
BUCKET1_CNT_SG | NUMBER | |||
BUCKET1_CNT_F | NUMBER | |||
BUCKET2_CNT_G | NUMBER | |||
BUCKET2_CNT_SG | NUMBER | |||
BUCKET2_CNT_F | NUMBER | |||
BUCKET3_CNT_G | NUMBER | |||
BUCKET3_CNT_SG | NUMBER | |||
BUCKET3_CNT_F | NUMBER | |||
BUCKET4_CNT_G | NUMBER | |||
BUCKET4_CNT_SG | NUMBER | |||
BUCKET4_CNT_F | NUMBER | |||
BUCKET5_CNT_G | NUMBER | |||
BUCKET5_CNT_SG | NUMBER | |||
BUCKET5_CNT_F | NUMBER | |||
BUCKET6_CNT_G | NUMBER | |||
BUCKET6_CNT_SG | NUMBER | |||
BUCKET6_CNT_F | NUMBER | |||
BUCKET7_CNT_G | NUMBER | |||
BUCKET7_CNT_SG | NUMBER | |||
BUCKET7_CNT_F | NUMBER | |||
BUCKET8_CNT_G | NUMBER | |||
BUCKET8_CNT_SG | NUMBER | |||
BUCKET8_CNT_F | NUMBER | |||
BUCKET9_CNT_G | NUMBER | |||
BUCKET9_CNT_SG | NUMBER | |||
BUCKET9_CNT_F | NUMBER | |||
BUCKET10_CNT_G | NUMBER | |||
BUCKET10_CNT_SG | NUMBER | |||
BUCKET10_CNT_F | NUMBER | |||
C_TOTAL | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT AUTHORING_ORG_ID
, RESOURCE_ID
, RG_ID
, REN_TYPE
, GRP_ID
, TIME_ID
, ENT_QTR_ID
, ENT_PERIOD_ID
, WEEK_ID
, DAY_ID
, BUCKET1_AMT_G
, BUCKET1_AMT_SG
, BUCKET1_AMT_F
, BUCKET2_AMT_G
, BUCKET2_AMT_SG
, BUCKET2_AMT_F
, BUCKET3_AMT_G
, BUCKET3_AMT_SG
, BUCKET3_AMT_F
, BUCKET4_AMT_G
, BUCKET4_AMT_SG
, BUCKET4_AMT_F
, BUCKET5_AMT_G
, BUCKET5_AMT_SG
, BUCKET5_AMT_F
, BUCKET6_AMT_G
, BUCKET6_AMT_SG
, BUCKET6_AMT_F
, BUCKET7_AMT_G
, BUCKET7_AMT_SG
, BUCKET7_AMT_F
, BUCKET8_AMT_G
, BUCKET8_AMT_SG
, BUCKET8_AMT_F
, BUCKET9_AMT_G
, BUCKET9_AMT_SG
, BUCKET9_AMT_F
, BUCKET10_AMT_G
, BUCKET10_AMT_SG
, BUCKET10_AMT_F
, BUCKET1_CNT_G
, BUCKET1_CNT_SG
, BUCKET1_CNT_F
, BUCKET2_CNT_G
, BUCKET2_CNT_SG
, BUCKET2_CNT_F
, BUCKET3_CNT_G
, BUCKET3_CNT_SG
, BUCKET3_CNT_F
, BUCKET4_CNT_G
, BUCKET4_CNT_SG
, BUCKET4_CNT_F
, BUCKET5_CNT_G
, BUCKET5_CNT_SG
, BUCKET5_CNT_F
, BUCKET6_CNT_G
, BUCKET6_CNT_SG
, BUCKET6_CNT_F
, BUCKET7_CNT_G
, BUCKET7_CNT_SG
, BUCKET7_CNT_F
, BUCKET8_CNT_G
, BUCKET8_CNT_SG
, BUCKET8_CNT_F
, BUCKET9_CNT_G
, BUCKET9_CNT_SG
, BUCKET9_CNT_F
, BUCKET10_CNT_G
, BUCKET10_CNT_SG
, BUCKET10_CNT_F
, C_TOTAL
FROM APPS.OKI_SRM_003_MV;
APPS.OKI_SRM_003_MV is not referenced by any database object
|
|
|