View: GMF_LOT_COST_ADJUSTMENTS_V

Product:	GMF - Process Manufacturing Financials
Description:	Internal View for Lot Cost Adjustments
Implementation/DBA Data:	APPS.GMF_LOT_COST_ADJUSTMENTS_V

View Text

SELECT ADJ.ADJUSTMENT_ID
, ADJ.LEGAL_ENTITY_ID
, ADJ.ORGANIZATION_ID
, ADJ.INVENTORY_ITEM_ID
, ITEM.ITEM_NUMBER
, ITEM.DESCRIPTION
, ADJ.COST_TYPE_ID
, MTHD.COST_MTHD_CODE
, MTHD.COST_MTHD_DESC
, NVL(ADJ.LOT_NUMBER
, ' ') AS LOT_NUMBER
, ADJ.ADJUSTMENT_DATE
, ADJ.REASON_CODE
, REAS.REASON_DESC
, ADJ.APPLIED_IND
, ADJ.GL_POSTED_IND
, ADJ.OLD_COST_HEADER_ID
, ADJ.NEW_COST_HEADER_ID
, ADJ.DELETE_MARK
, ADJ.TEXT_CODE
, ADJ.CREATED_BY
, ADJ.CREATION_DATE
, ADJ.LAST_UPDATED_BY
, ADJ.LAST_UPDATE_LOGIN
, ADJ.LAST_UPDATE_DATE
, ADJ.REQUEST_ID
, ADJ.PROGRAM_APPLICATION_ID
, ADJ.PROGRAM_ID
, ADJ.PROGRAM_UPDATE_DATE
, ADJ.ATTRIBUTE1
, ADJ.ATTRIBUTE2
, ADJ.ATTRIBUTE3
, ADJ.ATTRIBUTE4
, ADJ.ATTRIBUTE5
, ADJ.ATTRIBUTE6
, ADJ.ATTRIBUTE7
, ADJ.ATTRIBUTE8
, ADJ.ATTRIBUTE9
, ADJ.ATTRIBUTE10
, ADJ.ATTRIBUTE11
, ADJ.ATTRIBUTE12
, ADJ.ATTRIBUTE13
, ADJ.ATTRIBUTE14
, ADJ.ATTRIBUTE15
, ADJ.ATTRIBUTE16
, ADJ.ATTRIBUTE17
, ADJ.ATTRIBUTE18
, ADJ.ATTRIBUTE19
, ADJ.ATTRIBUTE20
, ADJ.ATTRIBUTE21
, ADJ.ATTRIBUTE22
, ADJ.ATTRIBUTE23
, ADJ.ATTRIBUTE24
, ADJ.ATTRIBUTE25
, ADJ.ATTRIBUTE26
, ADJ.ATTRIBUTE27
, ADJ.ATTRIBUTE28
, ADJ.ATTRIBUTE29
, ADJ.ATTRIBUTE30
, ADJ.ATTRIBUTE_CATEGORY
, ADJ.ONHAND_QTY
FROM GMF_LOT_COST_ADJUSTMENTS ADJ
, CM_MTHD_MST MTHD
, MTL_ITEM_FLEXFIELDS ITEM
, CM_REAS_CDS REAS
WHERE ITEM.INVENTORY_ITEM_ID = ADJ.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID = ADJ.ORGANIZATION_ID
AND MTHD.COST_TYPE_ID = ADJ.COST_TYPE_ID
AND REAS.REASON_CODE = ADJ.REASON_CODE

Columns