View: PMIFV_PROD_EFFI_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Batch Efficiency
Implementation/DBA Data:	APPS.PMIFV_PROD_EFFI_V

View Text

SELECT BTCHHDR.PLANT_CODE
, ORGNMST.CO_CODE
, BTCHHDR.WIP_WHSE_CODE
, BTCHHDR.BATCH_ID
, BTCHHDR.BATCH_NO
, BTCHDTL.ITEM_ID
, ITEMMST.ITEM_NO
, ITEMMST.ITEM_DESC1
, ITEMMST.PLANNING_CLASS
, ITEMMST.INV_CLASS
, ITEMMST.SALES_CLASS
, CALENDR.PERIOD_YEAR
, CALENDR.PERIOD_NUM
, CALENDR.PERIOD_NAME
, DECODE(BTCHDTL.ITEM_UM
, ITEMMST.ITEM_UM
, BTCHDTL.ACTUAL_QTY
, GMICUOM.I2UOM_CV(BTCHDTL.ITEM_ID
, 0
, BTCHDTL.ITEM_UM
, BTCHDTL.ACTUAL_QTY
, ITEMMST.ITEM_UM))
, PLNTINV.STD_QTY
, (PLNTINV.FIXED_LEADTIME + PLNTINV.VARIABLE_LEADTIME)
, GMICUOM.I2UOM_CV(BTCHDTL.ITEM_ID
, 0
, BTCHDTL.ITEM_UM
, BTCHDTL.PLAN_QTY
, ITEMMST.ITEM_UM)*PMI_COMMON_PKG.PMICO_GET_COST( BTCHDTL.ITEM_ID
, BTCHHDR.WIP_WHSE_CODE
, NULL
, BTCHHDR.ACTUAL_CMPLT_DATE)
, GMICUOM.I2UOM_CV(BTCHDTL.ITEM_ID
, 0
, BTCHDTL.ITEM_UM
, BTCHDTL.ACTUAL_QTY
, ITEMMST.ITEM_UM)*PMI_COMMON_PKG.PMICO_GET_COST( BTCHDTL.ITEM_ID
, BTCHHDR.WIP_WHSE_CODE
, NULL
, BTCHHDR.ACTUAL_CMPLT_DATE)
FROM GME_BATCH_HEADER BTCHHDR
, GME_MATERIAL_DETAILS BTCHDTL
, SY_ORGN_MST ORGNMST
, IC_ITEM_MST ITEMMST
, PMI_GL_CALENDAR_V CALENDR
, IC_PLNT_INV PLNTINV
, FM_FORM_MST_B FORMULA
WHERE BTCHHDR.BATCH_ID = BTCHDTL.BATCH_ID
AND BTCHHDR.PLANT_CODE = ORGNMST.ORGN_CODE
AND BTCHDTL.ITEM_ID = ITEMMST.ITEM_ID
AND FORMULA.FORMULA_ID = BTCHHDR.FORMULA_ID
AND BTCHHDR.BATCH_STATUS IN (3
, 4)
AND BTCHHDR.PLANT_CODE = PLNTINV.ORGN_CODE
AND ORGNMST.CO_CODE = CALENDR.CO_CODE
AND BTCHDTL.ITEM_ID = PLNTINV.ITEM_ID
AND BTCHDTL.LINE_TYPE=1
AND TRUNC(BTCHHDR.ACTUAL_CMPLT_DATE) BETWEEN CALENDR.START_DATE
AND CALENDR.END_DATE
AND (BTCHHDR.PLANT_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY

Columns