eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PMI_INV_CALENDAR_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Inventory Calendar View
Implementation/DBA Data:	APPS.PMI_INV_CALENDAR_V

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
, 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) )

Columns

Name
ORGN_CODE
FISCAL_YEAR
PERIOD_ID
PERIOD
CALENDAR_DESC
CLOSED_YEAR_IND
CURRENT_YEAR_IND
CLOSED_PERIOD_IND
CURRENT_PERIOD_IND
PERIOD_TYPE
PERIOD_DESC
END_DATE
START_DATE
CREATION_DATE
LAST_UPDATE_DATE