[Home] [Help]
View: PMIFV_BATCH_INPUT_V
Product: | PMI - Process Manufacturing Intelligence |
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
Name |
BATCH_ID |
PLAN_INGREDIENT_VALUE |
ACTUAL_INGREDIENT_VALUE |