[Home] [Help]
View: PMI_REP_QTR_ONHAND_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
Description: | This is view for PMI Quarterly On-Hand Inventory Report |
Implementation/DBA Data: |
APPS.PMI_REP_QTR_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.QUARTER_ID QUARTER_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 GLCLDR.PERIOD_START_DATE <= TRUNC(LOGTAB.LAST_RUN_DATE)
AND ( (GLCLDR.PERIOD_END_DATE = GLCLDR.QUARTER_END_DATE
AND TRUNC(LOGTAB.LAST_RUN_DATE) NOT BETWEEN GLCLDR.QUARTER_START_DATE
AND GLCLDR.QUARTER_END_DATE ) OR (TRUNC(LOGTAB.LAST_RUN_DATE) BETWEEN GLCLDR.PERIOD_START_DATE
AND GLCLDR.PERIOD_END_DATE))
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(SUMM_TAB.ORGN_CODE)
Columns
Name |
FISCAL_YEAR |
COMPANY_ID |
ORGANIZATION_ID |
WAREHOUSE_ID |
ITEM_ID |
ITEM_NO |
ITEM_UM |
WHSE_ONHAND_QTY |
WHSE_ONHAND_CONV |
WHSE_ONHAND_VALUE |
WHSE_SALE_QTY |
WHSE_SALE_CONV |
WHSE_SALE_VALUE |
PERIOD_NAME |
QUARTER_ID |