Skip to content

DBA Data[Home] [Help] [Dependency Information]

MATERIALIZED VIEW: APPS.OKI_SRM_003_MV

Object Details
Object Name: OKI_SRM_003_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
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
MV Log Dependencies:

BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS
FII_TIME_DAY
OKI_DBI_CLE_B

[View Source Query]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.OKI_SRM_003_MV references the following:

SchemaAPPS
TableOKI_SRM_003_MV
SchemaBIS
TableBIS_BUCKET
TableBIS_BUCKET_CUSTOMIZATIONS
SchemaFII
TableFII_TIME_DAY
SchemaOKI
TableOKI_DBI_CLE_B

APPS.OKI_SRM_003_MV is not referenced by any database object