View: MTL_GRADE_CHANGE_ERV

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_GRADE_CHANGE_ERV

View Text

SELECT LGH.GRADE_UPDATE_ID GRADE_UPDATE_ID
, LGH.ORGANIZATION_ID ORGANIZATION_ID
, LGH.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, H.NAME ORGANIZATION_NAME
, LGH.LOT_NUMBER LOT_NUMBER
, LGH.NEW_GRADE_CODE NEW_GRADE_CODE
, LGH.OLD_GRADE_CODE OLD_GRADE_CODE
, LGH.PRIMARY_QUANTITY PRIMARY_QUANTITY
, MSI.PRIMARY_UNIT_OF_MEASURE PRIMARY_UOM_CODE
, LGH.SECONDARY_QUANTITY SECONDARY_QUANTITY
, MSI.SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, MR.REASON_NAME REASON_NAME
, LGH.GRADE_UPDATE_DATE GRADE_UPDATE_DATE
, LGH.CREATED_BY CREATED_BY
, LGH.CREATION_DATE CREATION_DATE
, LGH.LAST_UPDATED_BY LAST_UPDATE_DATE
, LGH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LGH.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM MTL_LOT_GRADE_HISTORY LGH
, HR_ALL_ORGANIZATION_UNITS H
, MTL_PARAMETERS MP
, MTL_TRANSACTION_REASONS MR
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE LGH.ORGANIZATION_ID = H.ORGANIZATION_ID
AND H.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND LGH.UPDATE_REASON_ID = MR.REASON_ID(+)
AND LGH.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND LGH.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID

Columns