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

TABLE: APPS.DDR_R_CLNDR_MNTH_DN_MV

Object Details
Object Name: DDR_R_CLNDR_MNTH_DN_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.DDR_R_CLNDR_MNTH_DN_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
GMNTH_ROWID ROWID (10)
GQTR_ROWID ROWID (10)
GYR_ROWID ROWID (10)
MNTH_TRANS_ROWID ROWID (10)
CLNDR_DESC VARCHAR2 (36)
CLNDR_CD VARCHAR2 (30) Yes
CLNDR_TYPE VARCHAR2 (30) Yes
CLNDR_MNTH_ID NUMBER
Yes
MNTH_DESC VARCHAR2 (40) Yes
MNTH_CD VARCHAR2 (30) Yes
MNTH_STRT_DT DATE
Yes
MNTH_END_DT DATE
Yes
MNTH_NBR NUMBER
Yes
MNTH_TIMESPN NUMBER
Yes
LAST_YR_THIS_MNTH_ID NUMBER

LAST_MNTH_THIS_YR_ID NUMBER

CLNDR_QTR_ID NUMBER
Yes
QTR_DESC VARCHAR2 (40) Yes
QTR_NBR NUMBER
Yes
QTR_CD VARCHAR2 (30) Yes
QTR_STRT_DT DATE
Yes
QTR_END_DT DATE
Yes
QTR_TIMESPN NUMBER
Yes
CLNDR_YR_ID NUMBER
Yes
YR_DESC VARCHAR2 (40) Yes
YR_NBR NUMBER
Yes
YR_CD VARCHAR2 (30) Yes
YR_STRT_DT DATE
Yes
YR_END_DT DATE
Yes
YR_TIMESPN NUMBER
Yes
Query Text

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


SELECT GMNTH_ROWID
,      GQTR_ROWID
,      GYR_ROWID
,      MNTH_TRANS_ROWID
,      CLNDR_DESC
,      CLNDR_CD
,      CLNDR_TYPE
,      CLNDR_MNTH_ID
,      MNTH_DESC
,      MNTH_CD
,      MNTH_STRT_DT
,      MNTH_END_DT
,      MNTH_NBR
,      MNTH_TIMESPN
,      LAST_YR_THIS_MNTH_ID
,      LAST_MNTH_THIS_YR_ID
,      CLNDR_QTR_ID
,      QTR_DESC
,      QTR_NBR
,      QTR_CD
,      QTR_STRT_DT
,      QTR_END_DT
,      QTR_TIMESPN
,      CLNDR_YR_ID
,      YR_DESC
,      YR_NBR
,      YR_CD
,      YR_STRT_DT
,      YR_END_DT
,      YR_TIMESPN
FROM APPS.DDR_R_CLNDR_MNTH_DN_MV;

Dependencies

[top of page]

APPS.DDR_R_CLNDR_MNTH_DN_MV does not reference any database object

APPS.DDR_R_CLNDR_MNTH_DN_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_R_CLNDR_MNTH_DN_MV