eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AK_OBJECT_ATTRIBUTE_NAVIGATI_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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