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_MATERIAL_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Information on a batch and the ingredients, products, and byproducts of that batch.
Implementation/DBA Data:	APPS.PMIFV_BATCH_MATERIAL_V

View Text

SELECT BATCHHEADER.BATCH_ID
, BATCHHEADER.PLANT_CODE
, BATCHHEADER.BATCH_NO
, BATCHHEADER.BATCH_TYPE
, BATCHHEADER.PROD_ID
, BATCHHEADER.PROD_SEQUENCE
, BATCHHEADER.FORMULA_ID
, BATCHHEADER.ROUTING_ID
, BATCHHEADER.PLAN_START_DATE
, BATCHHEADER.ACTUAL_START_DATE
, BATCHHEADER.DUE_DATE
, BATCHHEADER.PLAN_CMPLT_DATE
, BATCHHEADER.ACTUAL_CMPLT_DATE
, BATCHHEADER.BATCH_STATUS
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING('BATCH_STATUS'
, BATCHHEADER.BATCH_STATUS)
, 1
, 80)
, BATCHHEADER.PRIORITY_VALUE
, BATCHHEADER.PRIORITY_CODE
, BATCHHEADER.PRINT_COUNT
, BATCHHEADER.RECIPE_VALIDITY_RULE_ID
, BATCHHEADER.FMCONTROL_CLASS
, BATCHHEADER.WIP_WHSE_CODE
, BATCHHEADER.BATCH_CLOSE_DATE
, BATCHHEADER.PARENTLINE_ID
, MATERIALDETAIL.MATERIAL_DETAIL_ID
, MATERIALDETAIL.FORMULALINE_ID
, MATERIALDETAIL.LINE_NO
, MATERIALDETAIL.ITEM_ID
, MATERIALDETAIL.LINE_TYPE
, SUBSTR(PMI_COST_ANALZ_PACK.GMCA_GET_MEANING('LINE_TYPE'
, MATERIALDETAIL.LINE_TYPE)
, 1
, 80)
, MATERIALDETAIL.PLAN_QTY
, NULL
, MATERIALDETAIL.ITEM_UM
, NULL
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, MATERIALDETAIL.ACTUAL_QTY
, NULL
, MATERIALDETAIL.RELEASE_TYPE
, MATERIALDETAIL.SCRAP_FACTOR
, MATERIALDETAIL.SCALE_TYPE
, MATERIALDETAIL.PHANTOM_TYPE
, MATERIALDETAIL.COST_ALLOC
, MATERIALDETAIL.ALLOC_IND
, MATERIALDETAIL.COST
, MATERIALDETAIL.PHANTOM_ID
, BATCHHEADER.CREATED_BY
, BATCHHEADER.CREATION_DATE
, BATCHHEADER.LAST_UPDATE_DATE
, BATCHHEADER.LAST_UPDATED_BY
FROM GME_BATCH_HEADER BATCHHEADER
, GME_MATERIAL_DETAILS MATERIALDETAIL
, IC_ITEM_MST ITEM
, FM_FORM_MST_B FORMULA
WHERE BATCHHEADER.BATCH_ID = MATERIALDETAIL.BATCH_ID
AND MATERIALDETAIL.ITEM_ID = ITEM.ITEM_ID
AND FORMULA.FORMULA_ID = BATCHHEADER.FORMULA_ID
AND BATCHHEADER.DELETE_MARK = 0
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(BATCHHEADER.PLANT_CODE) WITH READ ONLY

Columns

Name
BATCH_ID
PLANT_CODE
BATCH_NUMBER
BATCH_TYPE
PRODUCTION_ID
PRODUCTION_SEQUENCE
FORMULA_ID
ROUTING_ID
PLAN_START_DATE
ACTUAL_START_DATE
DUE_DATE
EXPECT_COMPLETION_DATE
ACTUAL_COMPLETION_DATE
BATCH_STATUS
BATCH_STATUS_MEANING
PRIORITY_VALUE
PRIORITY_CODE
PRINT_COUNT
FORMULA_EFFECTIVITY_ID
FMCONTROL_CLASS
WIP_WAREHOUSEE_CODE
BATCH_CLOSE_DATE
PARENTLINE_ID
LINE_ID
FORMULALINE_ID
LINE_NO
ITEM_ID
LINE_TYPE
LINE_TYPE_MEANING
PLAN_QTY
PLAN_QTY2
ITEM_UOM
ITEM_UOM2
ITEM_NUMBER
ITEM_DESCRIPTION
ACTUAL_QTY
ACTUAL_QTY2
RELEASE_TYPE
SCRAP_FACTOR
SCALE_TYPE
PHANTOM_TYPE
COST_ALLOC
ALLOC_IND
COST
PHANTOM_ID
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY