VIEW: APPS.DDR_TIME_BSNS_MNTH_V

Source

View Text - Preformatted

SELECT BMO.MFG_ORG_CD,CLNDR.ORG_CD,BMO.CLNDR_CD,CLNDR.CLNDR_DESC,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_BSNS_MNTH BMO,DDR_R_BSNS_QTR BQTR,DDR_R_BSNS_YR BYR,DDR_R_CLNDR CLNDR WHERE 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 BMO.MFG_ORG_CD
, CLNDR.ORG_CD
, BMO.CLNDR_CD
, CLNDR.CLNDR_DESC
, 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_BSNS_MNTH BMO
, DDR_R_BSNS_QTR BQTR
, DDR_R_BSNS_YR BYR
, DDR_R_CLNDR CLNDR
WHERE 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