View: OE_DEF_RELATED_OBJ_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_DEF_RELATED_OBJ_V

View Text

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

Columns