Product: | ONT - Order Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OE_DEF_RELATED_ATTR_V |
SELECT DISTINCT OA.DATABASE_OBJECT_NAME
, OA.ATTRIBUTE_CODE
, OA.ATTRIBUTE_APPLICATION_ID
, FK2.DATABASE_OBJECT_NAME RELATED_DATABASE_OBJECT_NAME
, OA2.OBJECT_NAME
, FKC2.ATTRIBUTE_CODE RELATED_ATTRIBUTE_CODE
, FKC2.ATTRIBUTE_APPLICATION_ID
, OA2.ATTRIBUTE_LABEL_LONG
, OA2.COLUMN_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