View: PMIFV_BATCH_INPUT_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Batch Input Details
Implementation/DBA Data:	APPS.PMIFV_BATCH_INPUT_V

View Text

SELECT BTCHHDR.BATCH_ID
, SUM(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))
, SUM(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
, IC_ITEM_MST ITEMMST
, FM_FORM_MST_B FORMULA
WHERE BTCHHDR.BATCH_ID = BTCHDTL.BATCH_ID
AND BTCHDTL.ITEM_ID = ITEMMST.ITEM_ID
AND BTCHHDR.FORMULA_ID = FORMULA.FORMULA_ID
AND BTCHHDR.BATCH_STATUS IN (3
, 4)
AND BTCHDTL.LINE_TYPE=-1
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(BTCHHDR.PLANT_CODE) GROUP BY BTCHHDR.BATCH_ID WITH READ ONLY

Columns