VIEW: APPS.EGO_ATTR_GROUP_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 ,EAGV.ATTR_GROUP_TYPE ATTR_GROUP_TYPE ,EAGV.ATTR_GROUP_NAME ATTR_GROUP_NAME ,EAGV.SECURITY_CODE SECURITY_CODE ,EAGV.OWNING_PARTY_ID OWNING_PARTY_ID ,EAGV.ATTR_GROUP_DISP_NAME ATTR_GROUP_DISP_NAME ,EAGV.ENABLED_CODE ENABLED_CODE ,EAGV.MULTI_ROW_CODE MULTI_ROW_CODE ,EAGV.MULTI_ROW_MEANING MULTI_ROW_MEANING ,EAGV.SECURITY_MEANING SECURITY_MEANING ,EAGV.ENABLED_MEANING ENABLED_MEANING ,EAGV.DESCRIPTION DESCRIPTION FROM EGO_OBJECT_EXT_TABLES_B EOET ,FND_TABLES FT ,FND_DESCRIPTIVE_FLEXS FDF ,FND_DESCRIPTIVE_FLEXS_TL FDFTL ,EGO_ATTR_GROUPS_V EAGV 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') AND FDF.APPLICATION_ID = EAGV.APPLICATION_ID AND FDF.DESCRIPTIVE_FLEXFIELD_NAME = EAGV.ATTR_GROUP_TYPE

View Text - HTML Formatted

SELECT EOET.APPLICATION_ID APPLICATION_ID
, EOET.OBJECT_ID OBJECT_ID
, FDFTL.DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEXFIELD_NAME
, EAGV.ATTR_GROUP_TYPE ATTR_GROUP_TYPE
, EAGV.ATTR_GROUP_NAME ATTR_GROUP_NAME
, EAGV.SECURITY_CODE SECURITY_CODE
, EAGV.OWNING_PARTY_ID OWNING_PARTY_ID
, EAGV.ATTR_GROUP_DISP_NAME ATTR_GROUP_DISP_NAME
, EAGV.ENABLED_CODE ENABLED_CODE
, EAGV.MULTI_ROW_CODE MULTI_ROW_CODE
, EAGV.MULTI_ROW_MEANING MULTI_ROW_MEANING
, EAGV.SECURITY_MEANING SECURITY_MEANING
, EAGV.ENABLED_MEANING ENABLED_MEANING
, EAGV.DESCRIPTION DESCRIPTION
FROM EGO_OBJECT_EXT_TABLES_B EOET
, FND_TABLES FT
, FND_DESCRIPTIVE_FLEXS FDF
, FND_DESCRIPTIVE_FLEXS_TL FDFTL
, EGO_ATTR_GROUPS_V EAGV
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')
AND FDF.APPLICATION_ID = EAGV.APPLICATION_ID
AND FDF.DESCRIPTIVE_FLEXFIELD_NAME = EAGV.ATTR_GROUP_TYPE