Product: | EGO - Advanced Product Catalog |
---|---|
Description: | View contains all the User-Defined Attribute Groups associated to an Object. |
Implementation/DBA Data: | APPS.EGO_ATTR_GROUP_OBJ_IDS_V |
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