View: AHL_ITEM_GROUPS_VL

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on the table AHL_ITEM_GROUPS_B and the translated columns from the table AHL_ITEM_GROUPS_TL.
Implementation/DBA Data:	APPS.AHL_ITEM_GROUPS_VL

View Text

SELECT AIGB.ROWID ROW_ID
, AIGB.ITEM_GROUP_ID
, AIGB.OBJECT_VERSION_NUMBER
, AIGB.LAST_UPDATE_DATE
, AIGB.LAST_UPDATED_BY
, AIGB.CREATION_DATE
, AIGB.CREATED_BY
, AIGB.LAST_UPDATE_LOGIN
, AIGB.NAME
, AIGT.DESCRIPTION
, AIGB.STATUS_CODE
, AIGB.TYPE_CODE
, AIGB.SOURCE_ITEM_GROUP_ID
, AIGB.ATTRIBUTE_CATEGORY
, AIGB.ATTRIBUTE1
, AIGB.ATTRIBUTE2
, AIGB.ATTRIBUTE3
, AIGB.ATTRIBUTE4
, AIGB.ATTRIBUTE5
, AIGB.ATTRIBUTE6
, AIGB.ATTRIBUTE7
, AIGB.ATTRIBUTE8
, AIGB.ATTRIBUTE9
, AIGB.ATTRIBUTE10
, AIGB.ATTRIBUTE11
, AIGB.ATTRIBUTE12
, AIGB.ATTRIBUTE13
, AIGB.ATTRIBUTE14
, AIGB.ATTRIBUTE15
FROM AHL_ITEM_GROUPS_B AIGB
, AHL_ITEM_GROUPS_TL AIGT
WHERE AIGB.ITEM_GROUP_ID = AIGT.ITEM_GROUP_ID
AND AIGT.LANGUAGE = USERENV('LANG')

Columns