View: CZBV_CONFIG_OBJECT_ATTRIBUTES

View Text

SELECT OBVL.NAME
, OB.ATTRIBUTE_CODE
, AT.NAME
, AP.APPLICATION_NAME
, OB.DATABASE_OBJECT_NAME
, OB.ATTRIBUTE_APPLICATION_ID
, OB.CREATION_DATE
, OB.CREATED_BY
, OB.LAST_UPDATE_DATE
, OB.LAST_UPDATED_BY
FROM FND_APPLICATION_VL AP
, AK_ATTRIBUTES_VL AT
, AK_OBJECTS_VL OBVL
, AK_OBJECT_ATTRIBUTES OB
WHERE OB.DATABASE_OBJECT_NAME = OBVL.DATABASE_OBJECT_NAME
AND OB.ATTRIBUTE_CODE = AT.ATTRIBUTE_CODE
AND OB.ATTRIBUTE_APPLICATION_ID = AT.ATTRIBUTE_APPLICATION_ID
AND OB.ATTRIBUTE_APPLICATION_ID = AP.APPLICATION_ID
AND OB.DATABASE_OBJECT_NAME = 'MTL_SYSTEM_ITEMS_KFV'
AND OB.ATTRIBUTE_APPLICATION_ID = 702 WITH READ ONLY

Columns