VIEW: APPS.PMI_REP_ONHAND_SALES_V

Source

View Text - Preformatted

SELECT psum.CO_CODE COMPANY_ID, psum.ORGN_CODE ORGANIZATION_ID, psum.whse_code WAREHOUSE_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_ONHAND_QTY, psum.WHSE_ONHAND_CONV, psum.WHSE_ONHAND_VALUE, psum.WHSE_SALE_QTY * -1 , psum.WHSE_SALE_CONV * -1 , psum.WHSE_SALE_VALUE * -1 , psum.PERIOD_NAME, glcldr.period_start_date s_date, glcldr.period_end_date e_date FROM PMI_ONHAND_SALE_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
, PSUM.WHSE_CODE WAREHOUSE_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_ONHAND_QTY
, PSUM.WHSE_ONHAND_CONV
, PSUM.WHSE_ONHAND_VALUE
, PSUM.WHSE_SALE_QTY * -1
, PSUM.WHSE_SALE_CONV * -1
, PSUM.WHSE_SALE_VALUE * -1
, PSUM.PERIOD_NAME
, GLCLDR.PERIOD_START_DATE S_DATE
, GLCLDR.PERIOD_END_DATE E_DATE
FROM PMI_ONHAND_SALE_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)