VIEW: APPS.PMI_INV_CALENDAR_V

Source

View Text - Preformatted

SELECT h.ORGN_CODE, h.FISCAL_YEAR, i1.PERIOD_ID, i1.PERIOD, h.CALENDAR_DESC, h.CLOSED_YEAR_IND , h.CURRENT_YEAR_IND, i1.CLOSED_PERIOD_IND, i1.CURRENT_PERIOD_IND, i1.PERIOD_TYPE, i1.PERIOD_DESC, i1.PERIOD_END_DATE END_DATE, decode(i1.period,1,h.begin_date,i2.period_end_date +1) Start_date, i1.CREATION_DATE, i1.LAST_UPDATE_DATE FROM ic_cldr_hdr h, ic_cldr_dtl i1, ic_cldr_dtl i2 WHERE h.orgn_code = i1.orgn_code and h.delete_mark = 0 and h.fiscal_year = i1.fiscal_year and h.orgn_code = i2.orgn_code and h.fiscal_year = i2.fiscal_year and ((i1.period = 1 and i1.period = i2.period) or (i1.period >1 and i2.period = i1.period -1) )

View Text - HTML Formatted

SELECT H.ORGN_CODE
, H.FISCAL_YEAR
, I1.PERIOD_ID
, I1.PERIOD
, H.CALENDAR_DESC
, H.CLOSED_YEAR_IND
, H.CURRENT_YEAR_IND
, I1.CLOSED_PERIOD_IND
, I1.CURRENT_PERIOD_IND
, I1.PERIOD_TYPE
, I1.PERIOD_DESC
, I1.PERIOD_END_DATE END_DATE
, DECODE(I1.PERIOD
, 1
, H.BEGIN_DATE
, I2.PERIOD_END_DATE +1) START_DATE
, I1.CREATION_DATE
, I1.LAST_UPDATE_DATE
FROM IC_CLDR_HDR H
, IC_CLDR_DTL I1
, IC_CLDR_DTL I2
WHERE H.ORGN_CODE = I1.ORGN_CODE
AND H.DELETE_MARK = 0
AND H.FISCAL_YEAR = I1.FISCAL_YEAR
AND H.ORGN_CODE = I2.ORGN_CODE
AND H.FISCAL_YEAR = I2.FISCAL_YEAR
AND ((I1.PERIOD = 1
AND I1.PERIOD = I2.PERIOD) OR (I1.PERIOD >1
AND I2.PERIOD = I1.PERIOD -1) )