View: PMI_REP_YR_ONHAND_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	This is view for PMI Yearly On-Hand Inventory Report
Implementation/DBA Data:	APPS.PMI_REP_YR_ONHAND_V

View Text

SELECT SUMM_TAB.FISCAL_YEAR
, SUMM_TAB.CO_CODE COMPANY_ID
, SUMM_TAB.ORGN_CODE ORGANIZATION_ID
, SUMM_TAB.WHSE_CODE WAREHOUSE_ID
, SUMM_TAB.ITEM_ID
, SUMM_TAB.ITEM_NO
, SUMM_TAB.ITEM_UM
, SUMM_TAB.WHSE_ONHAND_QTY
, SUMM_TAB.WHSE_ONHAND_CONV
, SUMM_TAB.WHSE_ONHAND_VALUE
, SUMM_TAB.WHSE_SALE_QTY
, SUMM_TAB.WHSE_SALE_CONV
, SUMM_TAB.WHSE_SALE_VALUE
, SUMM_TAB.PERIOD_NAME
, GLCLDR.YEAR_ID YEAR_ID FROM PMI_ONHAND_SALE_SUM SUMM_TAB
, PMI_GL_TIME_V GLCLDR
, GL_PLCY_MST PLCY
, PMI_SUMMARY_LOG_TABLE LOGTAB
WHERE SUMM_TAB.PERIOD_SET_NAME = GLCLDR.PERIOD_SET_NAME
AND SUMM_TAB.FISCAL_YEAR = GLCLDR.PERIOD_YEAR
AND SUMM_TAB.PERIOD_ID = GLCLDR.PERIOD_NUM
AND PLCY.CO_CODE = SUMM_TAB.CO_CODE
AND PLCY.SET_OF_BOOKS_NAME = GLCLDR.SET_OF_BOOKS_NAME
AND SUMMARY_TABLE = 'PMI_ONHAND_SALE_SUM'
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(SUMM_TAB.ORGN_CODE)
AND GLCLDR.PERIOD_START_DATE <= TRUNC(LOGTAB.LAST_RUN_DATE)
AND ( (GLCLDR.PERIOD_END_DATE = GLCLDR.YEAR_END_DATE
AND TRUNC(LOGTAB.LAST_RUN_DATE) NOT BETWEEN GLCLDR.YEAR_START_DATE
AND GLCLDR.YEAR_END_DATE ) OR (TRUNC(LOGTAB.LAST_RUN_DATE) BETWEEN GLCLDR.PERIOD_START_DATE
AND GLCLDR.PERIOD_END_DATE))

Columns