[Home] [Help] [Dependency Information]
Object Name: | OKI_SRM_003_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.OKI_SRM_003_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_OKI_SRM_003_MV | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_SUMMARY |
SYS_OP_MAP_NONNULL("AUTHORING_ORG_ID")
SYS_OP_MAP_NONNULL("RESOURCE_ID") SYS_OP_MAP_NONNULL("RG_ID") SYS_OP_MAP_NONNULL("REN_TYPE") SYS_OP_MAP_NONNULL("ENT_QTR_ID") SYS_OP_MAP_NONNULL("ENT_PERIOD_ID") SYS_OP_MAP_NONNULL("WEEK_ID") SYS_OP_MAP_NONNULL("DAY_ID") SYS_OP_MAP_NONNULL("GRP_ID") |
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 does not reference any database object
APPS.OKI_SRM_003_MV is referenced by following:
|
|
|