Product: | GME - Process Manufacturing Process Execution |
---|---|
Description: | View of Item / Step association with material definition |
Implementation/DBA Data: | APPS.GME_BATCH_STEP_ITEMS_V1 |
SELECT BSI.BATCHSTEP_ID
, MAT.MATERIAL_DETAIL_ID
, MAT.BATCH_ID
, MAT.FORMULALINE_ID
, MAT.LINE_NO
, MAT.ITEM_ID
, MAT.LINE_TYPE
, MAT.PLAN_QTY
, MAT.ITEM_UM
, MAT.ITEM_UM2
, MAT.ACTUAL_QTY
, MAT.RELEASE_TYPE
, MAT.SCRAP_FACTOR
, MAT.SCALE_TYPE
, MAT.PHANTOM_TYPE
, MAT.COST_ALLOC
, MAT.ALLOC_IND
, MAT.COST
, MAT.TEXT_CODE
, MAT.PHANTOM_ID
, MAT.ROUNDING_DIRECTION
, MAT.CREATION_DATE
, MAT.CREATED_BY
, MAT.LAST_UPDATE_DATE
, MAT.LAST_UPDATED_BY
, MAT.ATTRIBUTE1
, MAT.ATTRIBUTE2
, MAT.ATTRIBUTE3
, MAT.ATTRIBUTE4
, MAT.ATTRIBUTE5
, MAT.ATTRIBUTE6
, MAT.ATTRIBUTE7
, MAT.ATTRIBUTE8
, MAT.ATTRIBUTE9
, MAT.ATTRIBUTE10
, MAT.ATTRIBUTE11
, MAT.ATTRIBUTE12
, MAT.ATTRIBUTE13
, MAT.ATTRIBUTE14
, MAT.ATTRIBUTE15
, MAT.ATTRIBUTE16
, MAT.ATTRIBUTE17
, MAT.ATTRIBUTE18
, MAT.ATTRIBUTE19
, MAT.ATTRIBUTE20
, MAT.ATTRIBUTE21
, MAT.ATTRIBUTE22
, MAT.ATTRIBUTE23
, MAT.ATTRIBUTE24
, MAT.ATTRIBUTE25
, MAT.ATTRIBUTE26
, MAT.ATTRIBUTE27
, MAT.ATTRIBUTE28
, MAT.ATTRIBUTE29
, MAT.ATTRIBUTE30
, MAT.ATTRIBUTE_CATEGORY
, MAT.LAST_UPDATE_LOGIN
, MAT.SCALE_ROUNDING_VARIANCE
, MAT.SCALE_MULTIPLE
, MAT.CONTRIBUTE_YIELD_IND
, MAT.CONTRIBUTE_STEP_QTY_IND
, MAT.WIP_PLAN_QTY
, MAT.ORIGINAL_QTY
FROM GME_BATCH_STEP_ITEMS BSI
, GME_MATERIAL_DETAILS MAT
WHERE BSI.BATCH_ID = MAT.BATCH_ID
AND BSI.MATERIAL_DETAIL_ID = MAT.MATERIAL_DETAIL_ID