[Home] [Help]
View: PMI_REP_PROD_ACTUAL_PLAN_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
Description: | This is base view for PMI Production Variance Reports |
Implementation/DBA Data: |
APPS.PMI_REP_PROD_ACTUAL_PLAN_V
|
View Text
SELECT ORG.CO_CODE COMPANY_ID
, ORG.ORGN_CODE ORGANIZATION_ID
, GLCLDR.YEAR_ID YEAR_ID
, GLCLDR.QUARTER_ID QUARTER_ID
, GLCLDR.PERIOD_ID PERIOD_ID
, BDTL.LINE_TYPE LINE_TYPE
, GMICUOM.I2UOM_CV(BDTL.ITEM_ID
, 0
, BDTL.ITEM_UM
, BDTL.ACTUAL_QTY
, PROFILE.DEFAULT_UOM) ACTUAL_QTY
, GMICUOM.I2UOM_CV(BDTL.ITEM_ID
, 0
, BDTL.ITEM_UM
, BDTL.PLAN_QTY
, PROFILE.DEFAULT_UOM) PLAN_QTY
FROM GME_BATCH_HEADER BTCH
, GME_MATERIAL_DETAILS BDTL
, SY_ORGN_MST ORG
, GL_PLCY_MST FISCALPLCY
, PMI_GL_TIME_V GLCLDR
, (SELECT FND_PROFILE.VALUE('PMI$CONV_UOM') DEFAULT_UOM
FROM DUAL) PROFILE
WHERE BTCH.PLANT_CODE = ORG.ORGN_CODE
AND ORG.CO_CODE = FISCALPLCY.CO_CODE
AND BTCH.BATCH_ID = BDTL.BATCH_ID
AND GLCLDR.SET_OF_BOOKS_NAME = FISCALPLCY.SET_OF_BOOKS_NAME
AND BTCH.BATCH_STATUS IN (3
, 4)
AND BTCH.BATCH_TYPE = 0
AND BTCH.ACTUAL_CMPLT_DATE BETWEEN GLCLDR.PERIOD_START_DATE
AND GLCLDR.PERIOD_END_DATE
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(ORG.ORGN_CODE)
Columns
Name |
COMPANY_ID |
ORGANIZATION_ID |
YEAR_ID |
QUARTER_ID |
PERIOD_ID |
LINE_TYPE |
ACTUAL_QTY |
PLAN_QTY |