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

VIEW: APPS.DDR_R_BSNS_QTR_DN_MV#

Object Details
Object Name: DDR_R_BSNS_QTR_DN_MV#
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 16384 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "APPS_TS_SUMMARY"
BUILD DEFERRED
USING INDEX
REFRESH FORCE ON DEMAND
USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE

[View Source]

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# references the following:

SchemaAPPS
SynonymDDR_R_BSNS_QTR
SynonymDDR_R_BSNS_YR
SynonymDDR_R_CLNDR
SynonymDDR_R_QTR_TRANS

APPS.DDR_R_BSNS_QTR_DN_MV# is not referenced by any database object