VIEW: APPS.PMIFV_BATCH_INPUT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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