VIEW: APPS.DDR_TIME_BSNS_DAY_V

Source

View Text - Preformatted

SELECT BDAY.MFG_ORG_CD,CLNDR.ORG_CD,BDAY.CLNDR_CD,CLNDR.CLNDR_DESC,BDAY.DAY_CD,BDAY.DAY_OF_YR,BDAY.WKEND_IND,BDAY.CLNDR_STRT_DT,BDAY.CLNDR_END_DT,BWK.BSNS_WK_ID,BWK.WK_CD,BWK.WK_NBR,BWK.WK_DESC,BWK.WK_STRT_DT,BWK.WK_END_DT,BWK.WK_TIMESPN,BMO.BSNS_MNTH_ID,BMO.MNTH_CD,BMO.MNTH_NBR,BMO.MNTH_DESC,BMO.MNTH_STRT_DT,BMO.MNTH_END_DT,BMO.MNTH_TIMESPN,BQTR.BSNS_QTR_ID,BQTR.QTR_CD,BQTR.QTR_NBR,BQTR.QTR_DESC,BQTR.QTR_STRT_DT,BQTR.QTR_END_DT,BQTR.QTR_TIMESPN,BYR.BSNS_YR_ID,BYR.YR_CD,BYR.YR_NBR,BYR.YR_DESC,BYR.YR_STRT_DT,BYR.YR_END_DT,BYR.YR_TIMESPN FROM DDR_R_BASE_DAY BDAY,DDR_R_BSNS_WK BWK,DDR_R_BSNS_MNTH BMO,DDR_R_BSNS_QTR BQTR,DDR_R_BSNS_YR BYR,DDR_R_CLNDR CLNDR WHERE BDAY.WK_ID = BWK.BSNS_WK_ID AND BDAY.CLNDR_TYP = 'BSNS' AND BWK.BSNS_MNTH_ID = BMO.BSNS_MNTH_ID AND BMO.BSNS_QTR_ID = BQTR.BSNS_QTR_ID AND BQTR.BSNS_YR_ID = BYR.BSNS_YR_ID AND BYR.MFG_ORG_CD = CLNDR.MFG_ORG_CD AND BYR.CLNDR_CD = CLNDR.CLNDR_CD

View Text - HTML Formatted

SELECT BDAY.MFG_ORG_CD
, CLNDR.ORG_CD
, BDAY.CLNDR_CD
, CLNDR.CLNDR_DESC
, BDAY.DAY_CD
, BDAY.DAY_OF_YR
, BDAY.WKEND_IND
, BDAY.CLNDR_STRT_DT
, BDAY.CLNDR_END_DT
, BWK.BSNS_WK_ID
, BWK.WK_CD
, BWK.WK_NBR
, BWK.WK_DESC
, BWK.WK_STRT_DT
, BWK.WK_END_DT
, BWK.WK_TIMESPN
, BMO.BSNS_MNTH_ID
, BMO.MNTH_CD
, BMO.MNTH_NBR
, BMO.MNTH_DESC
, BMO.MNTH_STRT_DT
, BMO.MNTH_END_DT
, BMO.MNTH_TIMESPN
, BQTR.BSNS_QTR_ID
, BQTR.QTR_CD
, BQTR.QTR_NBR
, BQTR.QTR_DESC
, BQTR.QTR_STRT_DT
, BQTR.QTR_END_DT
, BQTR.QTR_TIMESPN
, BYR.BSNS_YR_ID
, BYR.YR_CD
, BYR.YR_NBR
, BYR.YR_DESC
, BYR.YR_STRT_DT
, BYR.YR_END_DT
, BYR.YR_TIMESPN
FROM DDR_R_BASE_DAY BDAY
, DDR_R_BSNS_WK BWK
, DDR_R_BSNS_MNTH BMO
, DDR_R_BSNS_QTR BQTR
, DDR_R_BSNS_YR BYR
, DDR_R_CLNDR CLNDR
WHERE BDAY.WK_ID = BWK.BSNS_WK_ID
AND BDAY.CLNDR_TYP = 'BSNS'
AND BWK.BSNS_MNTH_ID = BMO.BSNS_MNTH_ID
AND BMO.BSNS_QTR_ID = BQTR.BSNS_QTR_ID
AND BQTR.BSNS_YR_ID = BYR.BSNS_YR_ID
AND BYR.MFG_ORG_CD = CLNDR.MFG_ORG_CD
AND BYR.CLNDR_CD = CLNDR.CLNDR_CD