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

VIEW: APPS.DDR_TIME_FSCL_DAY_V

Object Details
Object Name: DDR_TIME_FSCL_DAY_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes
ORG_CD VARCHAR2 (30) Yes
CLNDR_CD VARCHAR2 (30) Yes
CLNDR_DESC VARCHAR2 (240)
DAY_CD VARCHAR2 (30) Yes
DAY_OF_YR NUMBER
Yes
WKEND_IND VARCHAR2 (1)
CLNDR_STRT_DT DATE
Yes
CLNDR_END_DT DATE
Yes
MNTH_ID NUMBER
Yes
MNTH_CD VARCHAR2 (30) Yes
MNTH_NBR NUMBER
Yes
MNTH_DESC VARCHAR2 (40) Yes
MNTH_STRT_DT DATE
Yes
MNTH_END_DT DATE
Yes
MNTH_TIMESPN NUMBER
Yes
QTR_ID NUMBER
Yes
QTR_CD VARCHAR2 (30) Yes
QTR_NBR NUMBER
Yes
QTR_DESC VARCHAR2 (40) Yes
QTR_STRT_DT DATE
Yes
QTR_END_DT DATE
Yes
QTR_TIMESPN NUMBER
Yes
YR_ID NUMBER
Yes
YR_CD VARCHAR2 (30) Yes
YR_NBR NUMBER
Yes
YR_DESC VARCHAR2 (40) 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 MFG_ORG_CD
,      ORG_CD
,      CLNDR_CD
,      CLNDR_DESC
,      DAY_CD
,      DAY_OF_YR
,      WKEND_IND
,      CLNDR_STRT_DT
,      CLNDR_END_DT
,      MNTH_ID
,      MNTH_CD
,      MNTH_NBR
,      MNTH_DESC
,      MNTH_STRT_DT
,      MNTH_END_DT
,      MNTH_TIMESPN
,      QTR_ID
,      QTR_CD
,      QTR_NBR
,      QTR_DESC
,      QTR_STRT_DT
,      QTR_END_DT
,      QTR_TIMESPN
,      YR_ID
,      YR_CD
,      YR_NBR
,      YR_DESC
,      YR_STRT_DT
,      YR_END_DT
,      YR_TIMESPN
FROM APPS.DDR_TIME_FSCL_DAY_V;

Dependencies

[top of page]

APPS.DDR_TIME_FSCL_DAY_V references the following:

SchemaAPPS
SynonymDDR_R_BASE_DAY
SynonymDDR_R_CLNDR
SynonymDDR_R_FSCL_MNTH
SynonymDDR_R_FSCL_QTR
SynonymDDR_R_FSCL_YR

APPS.DDR_TIME_FSCL_DAY_V is not referenced by any database object