View: UDA_SETUP_METADATA_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.UDA_SETUP_METADATA_V

View Text

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

Columns