View: MTL_ITEM_ORG_REV_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_ITEM_ORG_REV_V

View Text

SELECT MIR.ROWID ROW_ID
, MIR.INVENTORY_ITEM_ID
, MIR.ORGANIZATION_ID
, MP.MASTER_ORGANIZATION_ID
, DECODE(MIR.ORGANIZATION_ID
, MP.MASTER_ORGANIZATION_ID
, 0
, 1)
, MP.ORGANIZATION_CODE
, MIR.REVISION_ID
, MIR.REVISION
, MIR.REVISION_LABEL
, T.DESCRIPTION
, MIR.CHANGE_NOTICE
, MIR.ECN_INITIATION_DATE
, MIR.IMPLEMENTATION_DATE
, MIR.IMPLEMENTED_SERIAL_NUMBER
, MIR.EFFECTIVITY_DATE
, TO_CHAR(MIR.EFFECTIVITY_DATE
, 'HH24:MI:SS')
, MIR.ATTRIBUTE_CATEGORY
, MIR.ATTRIBUTE1
, MIR.ATTRIBUTE2
, MIR.ATTRIBUTE3
, MIR.ATTRIBUTE4
, MIR.ATTRIBUTE5
, MIR.ATTRIBUTE6
, MIR.ATTRIBUTE7
, MIR.ATTRIBUTE8
, MIR.ATTRIBUTE9
, MIR.ATTRIBUTE10
, MIR.ATTRIBUTE11
, MIR.ATTRIBUTE12
, MIR.ATTRIBUTE13
, MIR.ATTRIBUTE14
, MIR.ATTRIBUTE15
, MIR.REVISED_ITEM_SEQUENCE_ID
, MIR.CREATION_DATE
, MIR.CREATED_BY
, MIR.LAST_UPDATE_DATE
, MIR.LAST_UPDATED_BY
, MIR.LAST_UPDATE_LOGIN
, MIR.REQUEST_ID
, MIR.PROGRAM_APPLICATION_ID
, MIR.PROGRAM_ID
, MIR.PROGRAM_UPDATE_DATE
FROM MTL_ITEM_REVISIONS_TL T
, MTL_ITEM_REVISIONS_B MIR
, MTL_PARAMETERS MP
WHERE MIR.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND MIR.ORGANIZATION_ID = T.ORGANIZATION_ID
AND MIR.REVISION_ID = T.REVISION_ID
AND T.LANGUAGE = USERENV('LANG')
AND MP.ORGANIZATION_ID = MIR.ORGANIZATION_ID

Columns