View: PMIFV_BATCH_MATERIAL_V

Product:	PMI - Process Manufacturing Intelligence
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