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

TABLE: APPS.DDR_R_BSNS_QTR_DN_MV

Object Details
Object Name: DDR_R_BSNS_QTR_DN_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.DDR_R_BSNS_QTR_DN_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDR_R_BSNS_QTR_DN_MV_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnBSNS_QTR_ID
Columns
Name Datatype Length Mandatory Comments
BQTR_ROWID ROWID (10)
BYR_ROWID ROWID (10)
CAL_ROWID ROWID (10)
QTR_TRANS_ROWID ROWID (10)
MFG_ORG_CD VARCHAR2 (30) Yes
CLNDR_CD VARCHAR2 (30) Yes
ORG_CD VARCHAR2 (30) Yes
CLNDR_DESC VARCHAR2 (240)
BSNS_QTR_ID NUMBER
Yes
QTR_DESC VARCHAR2 (40) Yes
QTR_CD VARCHAR2 (30) Yes
QTR_NBR NUMBER
Yes
QTR_STRT_DT DATE
Yes
QTR_END_DT DATE
Yes
QTR_TIMESPN NUMBER
Yes
LAST_YR_THIS_QTR_ID NUMBER

LAST_QTR_THIS_YR_ID NUMBER

BSNS_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 BQTR_ROWID
,      BYR_ROWID
,      CAL_ROWID
,      QTR_TRANS_ROWID
,      MFG_ORG_CD
,      CLNDR_CD
,      ORG_CD
,      CLNDR_DESC
,      BSNS_QTR_ID
,      QTR_DESC
,      QTR_CD
,      QTR_NBR
,      QTR_STRT_DT
,      QTR_END_DT
,      QTR_TIMESPN
,      LAST_YR_THIS_QTR_ID
,      LAST_QTR_THIS_YR_ID
,      BSNS_YR_ID
,      YR_DESC
,      YR_NBR
,      YR_CD
,      YR_STRT_DT
,      YR_END_DT
,      YR_TIMESPN
FROM APPS.DDR_R_BSNS_QTR_DN_MV;

Dependencies

[top of page]

APPS.DDR_R_BSNS_QTR_DN_MV does not reference any database object

APPS.DDR_R_BSNS_QTR_DN_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_R_BSNS_QTR_DN_MV
Materialized ViewDDR_SV_CLS_YR_MV
ViewDDR_SV_CLS_YR_MV#
Materialized ViewDDR_SV_ITM_BU_ASSC_YR_MV
ViewDDR_SV_ITM_BU_ASSC_YR_MV#