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.OE_DEF_RELATED_OBJ_V

Source

View Text - Preformatted


SELECT distinct OA.database_object_name , OA.attribute_code , OA.attribute_application_id , FK2.database_object_name related_database_object_name , OA2.object_name from ak_object_attributes_vl OA , ak_foreign_key_columns FKC1 , ak_foreign_keys FK1 , ak_foreign_keys FK2 , ak_foreign_key_columns FKC2 , ak_foreign_keys FK3 , ak_unique_keys UK , ak_object_attributes_vl OA2 WHERE OA.attribute_code = FKC1.attribute_code and OA.database_object_name = FK1.database_object_name and FK1.foreign_key_name = FKC1.foreign_key_name and FK1.unique_key_name = FK2.unique_key_name and FK2.foreign_key_name = FKC2.foreign_key_name and FK2.database_object_name = UK.database_object_name and FK3.database_object_name = OA.database_object_name and FK3.unique_key_name = UK.unique_key_name and OA2.database_object_name = FK2.database_object_name and OA2.attribute_code = FKC2.attribute_code and OA2.attribute_application_id = FKC2.attribute_application_id

View Text - HTML Formatted

SELECT DISTINCT OA.DATABASE_OBJECT_NAME
, OA.ATTRIBUTE_CODE
, OA.ATTRIBUTE_APPLICATION_ID
, FK2.DATABASE_OBJECT_NAME RELATED_DATABASE_OBJECT_NAME
, OA2.OBJECT_NAME
FROM AK_OBJECT_ATTRIBUTES_VL OA
, AK_FOREIGN_KEY_COLUMNS FKC1
, AK_FOREIGN_KEYS FK1
, AK_FOREIGN_KEYS FK2
, AK_FOREIGN_KEY_COLUMNS FKC2
, AK_FOREIGN_KEYS FK3
, AK_UNIQUE_KEYS UK
, AK_OBJECT_ATTRIBUTES_VL OA2
WHERE OA.ATTRIBUTE_CODE = FKC1.ATTRIBUTE_CODE
AND OA.DATABASE_OBJECT_NAME = FK1.DATABASE_OBJECT_NAME
AND FK1.FOREIGN_KEY_NAME = FKC1.FOREIGN_KEY_NAME
AND FK1.UNIQUE_KEY_NAME = FK2.UNIQUE_KEY_NAME
AND FK2.FOREIGN_KEY_NAME = FKC2.FOREIGN_KEY_NAME
AND FK2.DATABASE_OBJECT_NAME = UK.DATABASE_OBJECT_NAME
AND FK3.DATABASE_OBJECT_NAME = OA.DATABASE_OBJECT_NAME
AND FK3.UNIQUE_KEY_NAME = UK.UNIQUE_KEY_NAME
AND OA2.DATABASE_OBJECT_NAME = FK2.DATABASE_OBJECT_NAME
AND OA2.ATTRIBUTE_CODE = FKC2.ATTRIBUTE_CODE
AND OA2.ATTRIBUTE_APPLICATION_ID = FKC2.ATTRIBUTE_APPLICATION_ID