VIEW: APPS.EGO_ATTR_GROUP_TYPE_OBJ_IDS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')