View: AHL_RELATIONSHIPS_VL

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

View Text

SELECT ARB.ROWID ROW_ID
, ARB.RELATIONSHIP_ID
, ARB.OBJECT_VERSION_NUMBER
, ARB.LAST_UPDATE_DATE
, ARB.LAST_UPDATED_BY
, ARB.CREATION_DATE
, ARB.CREATED_BY
, ARB.LAST_UPDATE_LOGIN
, ARB.POSITION_REF_CODE
, ARB.PARENT_RELATIONSHIP_ID
, ARB.NAME
, ARB.ITEM_GROUP_ID
, ARB.COUNTER_GROUP_ID
, ARB.UOM_CODE
, ARB.QUANTITY
, ARB.DISPLAY_ORDER
, ARB.SIBLING_RULES_FLAG
, ARB.COUNTER_RULE_FLAG
, ARB.POSITION_NECESSITY_CODE
, ARB.NODE_STATUS_FLAG
, ARB.CONFIG_STATUS_CODE
, ARB.ACTIVE_START_DATE
, ARB.ACTIVE_END_DATE
, ART.DESCRIPTION
, ARB.ATTRIBUTE_CATEGORY
, ARB.ATTRIBUTE1
, ARB.ATTRIBUTE2
, ARB.ATTRIBUTE3
, ARB.ATTRIBUTE4
, ARB.ATTRIBUTE5
, ARB.ATTRIBUTE6
, ARB.ATTRIBUTE7
, ARB.ATTRIBUTE8
, ARB.ATTRIBUTE9
, ARB.ATTRIBUTE10
, ARB.ATTRIBUTE11
, ARB.ATTRIBUTE12
, ARB.ATTRIBUTE13
, ARB.ATTRIBUTE14
, ARB.ATTRIBUTE15
FROM AHL_RELATIONSHIPS_B ARB
, AHL_RELATIONSHIPS_TL ART
WHERE ARB.RELATIONSHIP_ID = ART.RELATIONSHIP_ID
AND ART.LANGUAGE = USERENV('LANG')

Columns