VIEW: APPS.GMF_LOT_COST_ADJUSTMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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