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.

[Home] [Help]

View: PMIFV_BATCH_DETAILS_V

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

View Text

SELECT BTCHHDR.PLANT_CODE
, ORGNMST.CO_CODE
, BTCHHDR.WIP_WHSE_CODE
, BTCHHDR.BATCH_ID
, BTCHHDR.BATCH_NO
, BTCHHDR.FORMULA_ID
, FORMMST.FORMULA_NO
, FORMMST.FORMULA_VERS
, BTCHHDR.ROUTING_ID
, ROUTHDR.ROUTING_NO
, ROUTHDR.ROUTING_VERS
, BTCHHDR.PLAN_START_DATE
, BTCHHDR.ACTUAL_START_DATE
, BTCHHDR.PLAN_CMPLT_DATE
, BTCHHDR.ACTUAL_CMPLT_DATE
, BTCHHDR.BATCH_STATUS
, BTCHDTL.ITEM_ID
, ITEMMST.ITEM_NO
, ITEMMST.ITEM_DESC1
, ITEMMST.PLANNING_CLASS
, ITEMMST.INV_CLASS
, ITEMMST.SALES_CLASS
, ITEMMST.ITEM_UM
, BTCHDTL.ITEM_UM
, BTCHDTL.LINE_TYPE
, BTCHDTL.PLAN_QTY
, 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)
, BTCHDTL.ACTUAL_QTY
, 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)
, CALENDR.PERIOD_YEAR
, CALENDR.PERIOD_NUM
, CALENDR.PERIOD_NAME
, PLCYMST.BASE_CURRENCY_CODE
, PLCYMST.GL_COST_MTHD
FROM GME_BATCH_HEADER BTCHHDR
, GME_MATERIAL_DETAILS BTCHDTL
, SY_ORGN_MST ORGNMST
, IC_ITEM_MST ITEMMST
, FM_FORM_MST_VL FORMMST
, FM_ROUT_HDR ROUTHDR
, PMI_GL_CALENDAR_V CALENDR
, GL_PLCY_MST PLCYMST
WHERE BTCHHDR.BATCH_ID = BTCHDTL.BATCH_ID
AND BTCHHDR.PLANT_CODE = ORGNMST.ORGN_CODE
AND ORGNMST.CO_CODE = PLCYMST.CO_CODE
AND BTCHDTL.ITEM_ID = ITEMMST.ITEM_ID
AND BTCHHDR.FORMULA_ID = FORMMST.FORMULA_ID
AND BTCHHDR.ROUTING_ID = ROUTHDR.ROUTING_ID(+)
AND BTCHHDR.BATCH_STATUS IN (3
, 4)
AND BTCHDTL.LINE_TYPE=1
AND ORGNMST.CO_CODE = CALENDR.CO_CODE
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

Name
PLANT_CODE
COMPANY_CODE
WHSE_CODE
BATCH_ID
BATCH_NO
FORMULA_ID
FORMULA_NO
FORMULA_VERS
ROUTING_ID
ROUTING_NO
ROUTING_VERS
PLAN_START_DATE
ACTUAL_START_DATE
EXPCT_CMPLT_DATE
ACTUAL_CMPLT_DATE
BATCH_STATUS
ITEM_ID
ITEM_NO
ITEM_DESC
PLANNING_CLASS
INVENTORY_CLASS
SALES_CLASS
ITEM_UM
BTCH_ITEM_UM
LINE_TYPE
PLAN_QTY
PLAN_VALUE
ACTUAL_QTY
ACTUAL_VALUE
FISCAL_YEAR
PERIOD_CODE
PERIOD_NAME
BASE_CURRENCY
COST_METHOD