VIEW: APPS.DDR_TIME_CLNDR_MNTH_V

Source

View Text - Preformatted

SELECT CMO.CLNDR_MNTH_ID, CMO.MNTH_CD, CMO.MNTH_NBR, CMO.MNTH_DESC, CMO.MNTH_STRT_DT, CMO.MNTH_END_DT, CMO.MNTH_TIMESPN, CQTR.CLNDR_QTR_ID, CQTR.QTR_CD, CQTR.QTR_NBR, CQTR.QTR_DESC, CQTR.QTR_STRT_DT, CQTR.QTR_END_DT, CQTR.QTR_TIMESPN, CYR.CLNDR_YR_ID, CYR.YR_CD, CYR.YR_NBR, CYR.YR_DESC, CYR.YR_STRT_DT, CYR.YR_END_DT, CYR.YR_TIMESPN, 'CLNDR' CLNDR_CD, 'CLNDR' CLNDR_TYP, MFG_ORG.ORG_CD ORG_CD FROM DDR_R_CLNDR_MNTH CMO,DDR_R_CLNDR_QTR CQTR,DDR_R_CLNDR_YR CYR,DDR_R_ORG MFG_ORG WHERE CMO.CLNDR_QTR_ID = CQTR.CLNDR_QTR_ID AND CQTR.CLNDR_YR_ID = CYR.CLNDR_YR_ID AND MFG_ORG.ORG_TYP='MFG'

View Text - HTML Formatted

SELECT CMO.CLNDR_MNTH_ID
, CMO.MNTH_CD
, CMO.MNTH_NBR
, CMO.MNTH_DESC
, CMO.MNTH_STRT_DT
, CMO.MNTH_END_DT
, CMO.MNTH_TIMESPN
, CQTR.CLNDR_QTR_ID
, CQTR.QTR_CD
, CQTR.QTR_NBR
, CQTR.QTR_DESC
, CQTR.QTR_STRT_DT
, CQTR.QTR_END_DT
, CQTR.QTR_TIMESPN
, CYR.CLNDR_YR_ID
, CYR.YR_CD
, CYR.YR_NBR
, CYR.YR_DESC
, CYR.YR_STRT_DT
, CYR.YR_END_DT
, CYR.YR_TIMESPN
, 'CLNDR' CLNDR_CD
, 'CLNDR' CLNDR_TYP
, MFG_ORG.ORG_CD ORG_CD
FROM DDR_R_CLNDR_MNTH CMO
, DDR_R_CLNDR_QTR CQTR
, DDR_R_CLNDR_YR CYR
, DDR_R_ORG MFG_ORG
WHERE CMO.CLNDR_QTR_ID = CQTR.CLNDR_QTR_ID
AND CQTR.CLNDR_YR_ID = CYR.CLNDR_YR_ID
AND MFG_ORG.ORG_TYP='MFG'