View: GME_MATERIAL_DETAILS_V1

Product:	GME - Process Manufacturing Process Execution
Description:	This view is created for the backward compatibility. Batch or FPO material details. This table contains data on the products, ingredients, and by products of an FPO or batch, including the planned and actual quantity.
Implementation/DBA Data:	APPS.GME_MATERIAL_DETAILS_V1

View Text

SELECT BATCH_ID
, MATERIAL_DETAIL_ID
, FORMULALINE_ID
, LINE_NO
, ITEM_ID
, LINE_TYPE
, PLAN_QTY
, NULL
, ITEM_UM
, ITEM_UM2
, ACTUAL_QTY
, NULL
, RELEASE_TYPE
, SCRAP_FACTOR
, SCALE_TYPE
, PHANTOM_TYPE
, COST_ALLOC
, ALLOC_IND
, COST
, TEXT_CODE
, PHANTOM_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, NULL IN_USE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE_CATEGORY
, LAST_UPDATE_LOGIN
FROM GME_MATERIAL_DETAILS

Columns