View: INV_CALENDAR_VIEW

Product:	GMI - Process Manufacturing Inventory
Description:
Implementation/DBA Data:	APPS.INV_CALENDAR_VIEW

View Text

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
FROM IC_CLDR_HDR H
, IC_CLDR_DTL I1
, IC_CLDR_DTL I2
WHERE H.ORGN_CODE = I1.ORGN_CODE
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) )

Columns