View: MTL_CROSS_REFERENCES_VL

Product:	INV - Inventory
Description:	This table contains the columns of MTL_CROSS_REFERENCES_B and MTL_CROSS_REFERENCES_TL for current user's language settings
Implementation/DBA Data:	APPS.MTL_CROSS_REFERENCES_VL

View Text

SELECT BASE.ROWID
, BASE.CROSS_REFERENCE_ID
, BASE.INVENTORY_ITEM_ID
, BASE.ORGANIZATION_ID
, BASE.CROSS_REFERENCE_TYPE
, BASE.CROSS_REFERENCE
, TL.DESCRIPTION
, BASE.LAST_UPDATE_DATE
, BASE.LAST_UPDATED_BY
, BASE.CREATION_DATE
, BASE.CREATED_BY
, BASE.LAST_UPDATE_LOGIN
, BASE.REQUEST_ID
, BASE.PROGRAM_APPLICATION_ID
, BASE.PROGRAM_ID
, BASE.PROGRAM_UPDATE_DATE
, BASE.ATTRIBUTE_CATEGORY
, BASE.ATTRIBUTE1
, BASE.ATTRIBUTE2
, BASE.ATTRIBUTE3
, BASE.ATTRIBUTE4
, BASE.ATTRIBUTE5
, BASE.ATTRIBUTE6
, BASE.ATTRIBUTE7
, BASE.ATTRIBUTE8
, BASE.ATTRIBUTE9
, BASE.ATTRIBUTE10
, BASE.ATTRIBUTE11
, BASE.ATTRIBUTE12
, BASE.ATTRIBUTE13
, BASE.ATTRIBUTE14
, BASE.ATTRIBUTE15
, BASE.ORG_INDEPENDENT_FLAG
, BASE.UOM_CODE
, BASE.REVISION_ID
, BASE.EPC_GTIN_SERIAL
, BASE.SOURCE_SYSTEM_ID
, BASE.START_DATE_ACTIVE
, BASE.END_DATE_ACTIVE
, BASE.OBJECT_VERSION_NUMBER
FROM MTL_CROSS_REFERENCES_B BASE
, MTL_CROSS_REFERENCES_TL TL
WHERE BASE.CROSS_REFERENCE_ID = TL.CROSS_REFERENCE_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns