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.

VIEW: APPS.PMI_REP_TOP_10_PROD_INGRD_V

Source

View Text - Preformatted


SELECT psum.CO_CODE COMPANY_ID, psum.ORGN_CODE ORGANIZATION_ID, glcldr.YEAR_ID YEAR_ID, glcldr.QUARTER_ID QUARTER_ID, glcldr.PERIOD_ID PERIOD_ID, itemmst.item_id Item_id, psum.CONVERTIBLE_UOM UOM, psum.whse_yield_qty QTY_Produced, psum.WHSE_YIELD_value prod_Value , psum.whse_usage_qty * -1 QTY_Consumed, psum.whse_usage_value * -1 ingd_VALUE FROM PMI_PROD_SUM psum, gl_plcy_mst fiscalplcy, PMI_GL_TIME_V glcldr, ic_item_mst itemmst WHERE psum.co_code = fiscalplcy.co_code AND glcldr.set_of_books_name = fiscalplcy.SET_OF_BOOKS_NAME AND itemmst.item_id = psum.item_id AND psum.GL_PERIOD_START_DATE between glcldr.PERIOD_start_date and glcldr.PERIOD_end_date AND 'TRUE' = PMI_SECURITY_PKG.show_record(psum.orgn_code)

View Text - HTML Formatted

SELECT PSUM.CO_CODE COMPANY_ID
, PSUM.ORGN_CODE ORGANIZATION_ID
, GLCLDR.YEAR_ID YEAR_ID
, GLCLDR.QUARTER_ID QUARTER_ID
, GLCLDR.PERIOD_ID PERIOD_ID
, ITEMMST.ITEM_ID ITEM_ID
, PSUM.CONVERTIBLE_UOM UOM
, PSUM.WHSE_YIELD_QTY QTY_PRODUCED
, PSUM.WHSE_YIELD_VALUE PROD_VALUE
, PSUM.WHSE_USAGE_QTY * -1 QTY_CONSUMED
, PSUM.WHSE_USAGE_VALUE * -1 INGD_VALUE
FROM PMI_PROD_SUM PSUM
, GL_PLCY_MST FISCALPLCY
, PMI_GL_TIME_V GLCLDR
, IC_ITEM_MST ITEMMST
WHERE PSUM.CO_CODE = FISCALPLCY.CO_CODE
AND GLCLDR.SET_OF_BOOKS_NAME = FISCALPLCY.SET_OF_BOOKS_NAME
AND ITEMMST.ITEM_ID = PSUM.ITEM_ID
AND PSUM.GL_PERIOD_START_DATE BETWEEN GLCLDR.PERIOD_START_DATE
AND GLCLDR.PERIOD_END_DATE
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(PSUM.ORGN_CODE)