VIEW: APPS.UDA_SETUP_METADATA_V

Source

View Text - Preformatted

SELECT objextb.object_id object_id , objextb.APPLICATION_ID application_id, objextb.EXT_TABLE_NAME extension_table, realone.attr_group_type attr_group_type, templates.template_id template_id, templates.display_name template_name , templates.revision revision, realone.data_level_id data_level_id , realone.data_level_name data_level_name , realone.USER_data_level_name user_data_level_name from ego_data_level_vl dummy, ego_data_level_vl realone, fnd_descriptive_flexs fnddf, ego_object_ext_tables_b objextb, po_uda_AG_templates_vl templates WHERE dummy.attr_group_type like 'PO_UDA_DUMMY_EXT_ATTRS' and realone.attr_group_type = dummy.data_level_name and realone.data_level_name not like '%ARCHIVE' AND fnddf.descriptive_flexfield_name = realone.attr_group_type AND objextb.EXT_TABLE_NAME = fnddf.APPLICATION_TABLE_NAME AND templates.ENTITY_CODE(+) = realone.attr_group_type

View Text - HTML Formatted

SELECT OBJEXTB.OBJECT_ID OBJECT_ID
, OBJEXTB.APPLICATION_ID APPLICATION_ID
, OBJEXTB.EXT_TABLE_NAME EXTENSION_TABLE
, REALONE.ATTR_GROUP_TYPE ATTR_GROUP_TYPE
, TEMPLATES.TEMPLATE_ID TEMPLATE_ID
, TEMPLATES.DISPLAY_NAME TEMPLATE_NAME
, TEMPLATES.REVISION REVISION
, REALONE.DATA_LEVEL_ID DATA_LEVEL_ID
, REALONE.DATA_LEVEL_NAME DATA_LEVEL_NAME
, REALONE.USER_DATA_LEVEL_NAME USER_DATA_LEVEL_NAME
FROM EGO_DATA_LEVEL_VL DUMMY
, EGO_DATA_LEVEL_VL REALONE
, FND_DESCRIPTIVE_FLEXS FNDDF
, EGO_OBJECT_EXT_TABLES_B OBJEXTB
, PO_UDA_AG_TEMPLATES_VL TEMPLATES
WHERE DUMMY.ATTR_GROUP_TYPE LIKE 'PO_UDA_DUMMY_EXT_ATTRS'
AND REALONE.ATTR_GROUP_TYPE = DUMMY.DATA_LEVEL_NAME
AND REALONE.DATA_LEVEL_NAME NOT LIKE '%ARCHIVE'
AND FNDDF.DESCRIPTIVE_FLEXFIELD_NAME = REALONE.ATTR_GROUP_TYPE
AND OBJEXTB.EXT_TABLE_NAME = FNDDF.APPLICATION_TABLE_NAME
AND TEMPLATES.ENTITY_CODE(+) = REALONE.ATTR_GROUP_TYPE