[Home] [Help]
View: PMI_REP_TOP_10_PROD_INGRD_V
Product: | PMI - Process Manufacturing Intelligence |
Description: | This view is used for PMI Production Reports |
Implementation/DBA Data: |
APPS.PMI_REP_TOP_10_PROD_INGRD_V
|
View Text
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)
Columns
Name |
COMPANY_ID |
ORGANIZATION_ID |
YEAR_ID |
QUARTER_ID |
PERIOD_ID |
ITEM_ID |
UOM |
QTY_PRODUCED |
PROD_VALUE |
QTY_CONSUMED |
INGD_VALUE |