View: EGO_ATTR_GROUP_TYPE_OBJ_IDS_V

Product:	EGO - Advanced Product Catalog
Description:	View contains all the User-Defined Attribute Group Types associated to an Object.
Implementation/DBA Data:	APPS.EGO_ATTR_GROUP_TYPE_OBJ_IDS_V

View Text

SELECT EOET.APPLICATION_ID APPLICATION_ID
, EOET.OBJECT_ID OBJECT_ID
, FDFTL.DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEXFIELD_NAME
, FDFTL.DESCRIPTIVE_FLEXFIELD_NAME ATTR_GROUP_TYPE_NAME
, FDFTL.TITLE ATTR_GROUP_TYPE_DISP_NAME
FROM EGO_OBJECT_EXT_TABLES_B EOET
, FND_TABLES FT
, FND_DESCRIPTIVE_FLEXS FDF
, FND_DESCRIPTIVE_FLEXS_TL FDFTL
WHERE EOET.APPLICATION_ID = FT.APPLICATION_ID
AND EOET.EXT_TABLE_NAME = FT.TABLE_NAME
AND EOET.APPLICATION_ID = FDF.APPLICATION_ID
AND EOET.EXT_TABLE_NAME = FDF.APPLICATION_TABLE_NAME
AND FDF.APPLICATION_ID = FDFTL.APPLICATION_ID
AND FDF.DESCRIPTIVE_FLEXFIELD_NAME = FDFTL.DESCRIPTIVE_FLEXFIELD_NAME
AND FDFTL.LANGUAGE = USERENV('LANG')

Columns