eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PMIFV_PROD_EFFI_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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