VIEW: APPS.MTL_GRADE_CHANGE_ERV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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