VIEW: APPS.AK_OBJECT_ATTRIBUTES_VL

Source

View Text - Preformatted

SELECT AOA.ROWID ROW_ID , AOA.DATABASE_OBJECT_NAME , AOT.NAME OBJECT_NAME , AOT.DESCRIPTION OBJECT_DESCRIPTION , AOA.ATTRIBUTE_APPLICATION_ID , FAV.APPLICATION_SHORT_NAME , FAV.APPLICATION_NAME , AOA.ATTRIBUTE_CODE , AAT.NAME , AA.DATA_TYPE , ART1.NAME LOV_REGION_NAME , AAT1.NAME LOV_ATTRIBUTE_NAME , AOA.COLUMN_NAME , AOAT.ATTRIBUTE_LABEL_LONG , AOAT.ATTRIBUTE_LABEL_SHORT , AOA.ATTRIBUTE_LABEL_LENGTH , AOA.BOLD , AOA.ITALIC , AOA.HORIZONTAL_ALIGNMENT , AOA.VERTICAL_ALIGNMENT , AOA.DATA_SOURCE_TYPE , AOA.DATA_STORAGE_TYPE , AOA.TABLE_NAME , AOA.BASE_TABLE_COLUMN_NAME , AOA.REQUIRED_FLAG , AOA.DISPLAY_VALUE_LENGTH , AOA.LOV_REGION_APPLICATION_ID , AOA.LOV_REGION_CODE , AOA.LOV_FOREIGN_KEY_NAME , AOA.LOV_ATTRIBUTE_APPLICATION_ID , AOA.LOV_ATTRIBUTE_CODE , AOA.DEFAULTING_API_PKG , AOA.DEFAULTING_API_PROC , AOA.VALIDATION_API_PKG , AOA.VALIDATION_API_PROC ,AOA.DEFAULT_VALUE_VARCHAR2 ,AOA.DEFAULT_VALUE_NUMBER ,AOA.DEFAULT_VALUE_DATE , AOA.TRANSLATION_FLAG , AOA.ATTRIBUTE_CATEGORY , AOA.ATTRIBUTE1 , AOA.ATTRIBUTE2 , AOA.ATTRIBUTE3 , AOA.ATTRIBUTE4 , AOA.ATTRIBUTE5 , AOA.ATTRIBUTE6 , AOA.ATTRIBUTE7 , AOA.ATTRIBUTE8 , AOA.ATTRIBUTE9 , AOA.ATTRIBUTE10 , AOA.ATTRIBUTE11 , AOA.ATTRIBUTE12 , AOA.ATTRIBUTE13 , AOA.ATTRIBUTE14 , AOA.ATTRIBUTE15 , AOA.CREATED_BY , AOA.CREATION_DATE , AOA.LAST_UPDATED_BY , AOA.LAST_UPDATE_DATE , AOA.LAST_UPDATE_LOGIN FROM FND_APPLICATION_VL FAV, AK_OBJECTS_TL AOT, AK_REGIONS_TL ART1, AK_OBJECT_ATTRIBUTES_TL AOAT, AK_OBJECT_ATTRIBUTES AOA, AK_ATTRIBUTES_TL AAT, AK_ATTRIBUTES AA, AK_ATTRIBUTES_TL AAT1 WHERE AOA.DATABASE_OBJECT_NAME = AOT.DATABASE_OBJECT_NAME AND AOT.LANGUAGE = USERENV('LANG') AND AAT.ATTRIBUTE_CODE = AOA.ATTRIBUTE_CODE AND AAT.ATTRIBUTE_APPLICATION_ID = AOA.ATTRIBUTE_APPLICATION_ID AND AAT.LANGUAGE = USERENV('LANG') AND AA.ATTRIBUTE_CODE = AOA.ATTRIBUTE_CODE AND AA.ATTRIBUTE_APPLICATION_ID = AOA.ATTRIBUTE_APPLICATION_ID AND ART1.REGION_CODE(+) = AOA.LOV_REGION_CODE AND ART1.REGION_APPLICATION_ID(+) = AOA.LOV_REGION_APPLICATION_ID AND ART1.LANGUAGE(+) = USERENV('LANG') AND AAT1.ATTRIBUTE_CODE(+) = AOA.LOV_ATTRIBUTE_CODE AND AAT1.ATTRIBUTE_APPLICATION_ID(+) = AOA.LOV_ATTRIBUTE_APPLICATION_ID AND AAT1.LANGUAGE(+) = USERENV('LANG') AND AOA.ATTRIBUTE_APPLICATION_ID = FAV.APPLICATION_ID AND AOAT.DATABASE_OBJECT_NAME = AOA.DATABASE_OBJECT_NAME AND AOAT.ATTRIBUTE_APPLICATION_ID = AOA.ATTRIBUTE_APPLICATION_ID AND AOAT.ATTRIBUTE_CODE = AOA.ATTRIBUTE_CODE AND AOAT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT AOA.ROWID ROW_ID
, AOA.DATABASE_OBJECT_NAME
, AOT.NAME OBJECT_NAME
, AOT.DESCRIPTION OBJECT_DESCRIPTION
, AOA.ATTRIBUTE_APPLICATION_ID
, FAV.APPLICATION_SHORT_NAME
, FAV.APPLICATION_NAME
, AOA.ATTRIBUTE_CODE
, AAT.NAME
, AA.DATA_TYPE
, ART1.NAME LOV_REGION_NAME
, AAT1.NAME LOV_ATTRIBUTE_NAME
, AOA.COLUMN_NAME
, AOAT.ATTRIBUTE_LABEL_LONG
, AOAT.ATTRIBUTE_LABEL_SHORT
, AOA.ATTRIBUTE_LABEL_LENGTH
, AOA.BOLD
, AOA.ITALIC
, AOA.HORIZONTAL_ALIGNMENT
, AOA.VERTICAL_ALIGNMENT
, AOA.DATA_SOURCE_TYPE
, AOA.DATA_STORAGE_TYPE
, AOA.TABLE_NAME
, AOA.BASE_TABLE_COLUMN_NAME
, AOA.REQUIRED_FLAG
, AOA.DISPLAY_VALUE_LENGTH
, AOA.LOV_REGION_APPLICATION_ID
, AOA.LOV_REGION_CODE
, AOA.LOV_FOREIGN_KEY_NAME
, AOA.LOV_ATTRIBUTE_APPLICATION_ID
, AOA.LOV_ATTRIBUTE_CODE
, AOA.DEFAULTING_API_PKG
, AOA.DEFAULTING_API_PROC
, AOA.VALIDATION_API_PKG
, AOA.VALIDATION_API_PROC
, AOA.DEFAULT_VALUE_VARCHAR2
, AOA.DEFAULT_VALUE_NUMBER
, AOA.DEFAULT_VALUE_DATE
, AOA.TRANSLATION_FLAG
, AOA.ATTRIBUTE_CATEGORY
, AOA.ATTRIBUTE1
, AOA.ATTRIBUTE2
, AOA.ATTRIBUTE3
, AOA.ATTRIBUTE4
, AOA.ATTRIBUTE5
, AOA.ATTRIBUTE6
, AOA.ATTRIBUTE7
, AOA.ATTRIBUTE8
, AOA.ATTRIBUTE9
, AOA.ATTRIBUTE10
, AOA.ATTRIBUTE11
, AOA.ATTRIBUTE12
, AOA.ATTRIBUTE13
, AOA.ATTRIBUTE14
, AOA.ATTRIBUTE15
, AOA.CREATED_BY
, AOA.CREATION_DATE
, AOA.LAST_UPDATED_BY
, AOA.LAST_UPDATE_DATE
, AOA.LAST_UPDATE_LOGIN
FROM FND_APPLICATION_VL FAV
, AK_OBJECTS_TL AOT
, AK_REGIONS_TL ART1
, AK_OBJECT_ATTRIBUTES_TL AOAT
, AK_OBJECT_ATTRIBUTES AOA
, AK_ATTRIBUTES_TL AAT
, AK_ATTRIBUTES AA
, AK_ATTRIBUTES_TL AAT1
WHERE AOA.DATABASE_OBJECT_NAME = AOT.DATABASE_OBJECT_NAME
AND AOT.LANGUAGE = USERENV('LANG')
AND AAT.ATTRIBUTE_CODE = AOA.ATTRIBUTE_CODE
AND AAT.ATTRIBUTE_APPLICATION_ID = AOA.ATTRIBUTE_APPLICATION_ID
AND AAT.LANGUAGE = USERENV('LANG')
AND AA.ATTRIBUTE_CODE = AOA.ATTRIBUTE_CODE
AND AA.ATTRIBUTE_APPLICATION_ID = AOA.ATTRIBUTE_APPLICATION_ID
AND ART1.REGION_CODE(+) = AOA.LOV_REGION_CODE
AND ART1.REGION_APPLICATION_ID(+) = AOA.LOV_REGION_APPLICATION_ID
AND ART1.LANGUAGE(+) = USERENV('LANG')
AND AAT1.ATTRIBUTE_CODE(+) = AOA.LOV_ATTRIBUTE_CODE
AND AAT1.ATTRIBUTE_APPLICATION_ID(+) = AOA.LOV_ATTRIBUTE_APPLICATION_ID
AND AAT1.LANGUAGE(+) = USERENV('LANG')
AND AOA.ATTRIBUTE_APPLICATION_ID = FAV.APPLICATION_ID
AND AOAT.DATABASE_OBJECT_NAME = AOA.DATABASE_OBJECT_NAME
AND AOAT.ATTRIBUTE_APPLICATION_ID = AOA.ATTRIBUTE_APPLICATION_ID
AND AOAT.ATTRIBUTE_CODE = AOA.ATTRIBUTE_CODE
AND AOAT.LANGUAGE = USERENV('LANG')