View: AK_OBJECT_ATTRIBUTE_NAVIGATI_V

Product:	AK - Common Modules-AK
Description:	10SC ONLY
Implementation/DBA Data:	APPS.AK_OBJECT_ATTRIBUTE_NAVIGATI_V

View Text

SELECT AOAN.ROWID ROW_ID
, AOAN.DATABASE_OBJECT_NAME
, AOT.NAME OBJECT_NAME
, AOT.DESCRIPTION OBJECT_DESCRIPTION
, AOAN.ATTRIBUTE_APPLICATION_ID
, AOAN.ATTRIBUTE_CODE
, AAT.NAME ATTRIBUTE_NAME
, AOAN.VALUE_VARCHAR2
, AOAN.VALUE_DATE
, AOAN.VALUE_NUMBER
, AOAN.TO_REGION_APPL_ID
, AOAN.TO_REGION_CODE
, ART.NAME TO_REGION_NAME
, ART.DESCRIPTION TO_REGION_DESCRIPTION
, AA.DATA_TYPE
, AOAN.ATTRIBUTE_CATEGORY
, AOAN.ATTRIBUTE1
, AOAN.ATTRIBUTE2
, AOAN.ATTRIBUTE3
, AOAN.ATTRIBUTE4
, AOAN.ATTRIBUTE5
, AOAN.ATTRIBUTE6
, AOAN.ATTRIBUTE7
, AOAN.ATTRIBUTE8
, AOAN.ATTRIBUTE9
, AOAN.ATTRIBUTE10
, AOAN.ATTRIBUTE11
, AOAN.ATTRIBUTE12
, AOAN.ATTRIBUTE13
, AOAN.ATTRIBUTE14
, AOAN.ATTRIBUTE15
, AOAN.CREATED_BY
, AOAN.CREATION_DATE
, AOAN.LAST_UPDATED_BY
, AOAN.LAST_UPDATE_DATE
, AOAN.LAST_UPDATE_LOGIN
FROM AK_REGIONS_TL ART
, AK_OBJECTS_TL AOT
, AK_ATTRIBUTES_TL AAT
, AK_OBJECT_ATTRIBUTE_NAVIGATION AOAN
, AK_ATTRIBUTES AA
WHERE AOAN.TO_REGION_APPL_ID = ART.REGION_APPLICATION_ID
AND AOAN.TO_REGION_CODE = ART.REGION_CODE
AND ART.LANGUAGE = USERENV('LANG')
AND AOAN.DATABASE_OBJECT_NAME = AOT.DATABASE_OBJECT_NAME
AND AOT.LANGUAGE = USERENV('LANG')
AND AAT.ATTRIBUTE_CODE = AOAN.ATTRIBUTE_CODE
AND AAT.ATTRIBUTE_APPLICATION_ID = AOAN.ATTRIBUTE_APPLICATION_ID
AND AAT.LANGUAGE = USERENV('LANG')
AND AA.ATTRIBUTE_CODE = AAT.ATTRIBUTE_CODE
AND AA.ATTRIBUTE_APPLICATION_ID = AAT.ATTRIBUTE_APPLICATION_ID

Columns