VIEW: APPS.DDR_TIME_FSCL_DAY_V

Source

View Text - Preformatted

SELECT FDAY.MFG_ORG_CD,CLNDR.ORG_CD,FDAY.CLNDR_CD,CLNDR.CLNDR_DESC,FDAY.DAY_CD,FDAY.DAY_OF_YR,FDAY.WKEND_IND,FDAY.CLNDR_STRT_DT,FDAY.CLNDR_END_DT,FMO.FSCL_MNTH_ID,FMO.MNTH_CD,FMO.MNTH_NBR,FMO.MNTH_DESC,FMO.MNTH_STRT_DT,FMO.MNTH_END_DT,FMO.MNTH_TIMESPN,FQTR.FSCL_QTR_ID,FQTR.QTR_CD,FQTR.QTR_NBR,FQTR.QTR_DESC,FQTR.QTR_STRT_DT,FQTR.QTR_END_DT,FQTR.QTR_TIMESPN,FYR.FSCL_YR_ID,FYR.YR_CD,FYR.YR_NBR,FYR.YR_DESC,FYR.YR_STRT_DT,FYR.YR_END_DT,FYR.YR_TIMESPN FROM DDR_R_BASE_DAY FDAY,DDR_R_FSCL_MNTH FMO,DDR_R_FSCL_QTR FQTR,DDR_R_FSCL_YR FYR,DDR_R_CLNDR CLNDR WHERE FDAY.MNTH_ID = FMO.FSCL_MNTH_ID AND FDAY.CLNDR_TYP = 'FSCL' AND FMO.FSCL_QTR_ID = FQTR.FSCL_QTR_ID AND FQTR.FSCL_YR_ID = FYR.FSCL_YR_ID AND FYR.MFG_ORG_CD = CLNDR.MFG_ORG_CD AND FYR.CLNDR_CD = CLNDR.CLNDR_CD

View Text - HTML Formatted

SELECT FDAY.MFG_ORG_CD
, CLNDR.ORG_CD
, FDAY.CLNDR_CD
, CLNDR.CLNDR_DESC
, FDAY.DAY_CD
, FDAY.DAY_OF_YR
, FDAY.WKEND_IND
, FDAY.CLNDR_STRT_DT
, FDAY.CLNDR_END_DT
, FMO.FSCL_MNTH_ID
, FMO.MNTH_CD
, FMO.MNTH_NBR
, FMO.MNTH_DESC
, FMO.MNTH_STRT_DT
, FMO.MNTH_END_DT
, FMO.MNTH_TIMESPN
, FQTR.FSCL_QTR_ID
, FQTR.QTR_CD
, FQTR.QTR_NBR
, FQTR.QTR_DESC
, FQTR.QTR_STRT_DT
, FQTR.QTR_END_DT
, FQTR.QTR_TIMESPN
, FYR.FSCL_YR_ID
, FYR.YR_CD
, FYR.YR_NBR
, FYR.YR_DESC
, FYR.YR_STRT_DT
, FYR.YR_END_DT
, FYR.YR_TIMESPN
FROM DDR_R_BASE_DAY FDAY
, DDR_R_FSCL_MNTH FMO
, DDR_R_FSCL_QTR FQTR
, DDR_R_FSCL_YR FYR
, DDR_R_CLNDR CLNDR
WHERE FDAY.MNTH_ID = FMO.FSCL_MNTH_ID
AND FDAY.CLNDR_TYP = 'FSCL'
AND FMO.FSCL_QTR_ID = FQTR.FSCL_QTR_ID
AND FQTR.FSCL_YR_ID = FYR.FSCL_YR_ID
AND FYR.MFG_ORG_CD = CLNDR.MFG_ORG_CD
AND FYR.CLNDR_CD = CLNDR.CLNDR_CD