VIEW: APPS.AHL_RELATIONSHIPS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')