VIEW: APPS.PMI_REP_YR_ONHAND_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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