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


TABLE: APPS.DDR_R_CLNDR_WK_DN_MV

Object Details
Object Name: DDR_R_CLNDR_WK_DN_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.DDR_R_CLNDR_WK_DN_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
GWK_ROWID ROWID (10)
WK_TRANS_ROWID ROWID (10)
CLNDR_DESC VARCHAR2 (36)
CLNDR_CD VARCHAR2 (30) Yes
CLNDR_TYPE VARCHAR2 (30) Yes
CLNDR_WK_ID NUMBER
Yes
WK_CD VARCHAR2 (30) Yes
WK_NBR NUMBER
Yes
WK_DESC VARCHAR2 (40) Yes
WK_STRT_DT DATE
Yes
WK_END_DT DATE
Yes
WK_TIMESPN NUMBER
Yes
LAST_WK_THIS_YR_ID NUMBER

LAST_YR_THIS_WK_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GWK_ROWID
,      WK_TRANS_ROWID
,      CLNDR_DESC
,      CLNDR_CD
,      CLNDR_TYPE
,      CLNDR_WK_ID
,      WK_CD
,      WK_NBR
,      WK_DESC
,      WK_STRT_DT
,      WK_END_DT
,      WK_TIMESPN
,      LAST_WK_THIS_YR_ID
,      LAST_YR_THIS_WK_ID
FROM APPS.DDR_R_CLNDR_WK_DN_MV;

Dependencies

[top of page]

APPS.DDR_R_CLNDR_WK_DN_MV does not reference any database object

APPS.DDR_R_CLNDR_WK_DN_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_R_CLNDR_WK_DN_MV