View: EGO_ITMATTR_APPL_USGS_V

Product:	EGO - Advanced Product Catalog
Description:	View contains all the Attribute Groups enabled for an application.
Implementation/DBA Data:	APPS.EGO_ITMATTR_APPL_USGS_V

View Text

SELECT USGS.ATTR_GROUP_ID ATTR_GROUP_ID
, ATTRS.APPLICATION_ID ATTR_GROUP_APPLICATION_ID
, ATTRS.ATTR_GROUP_TYPE ATTR_GROUP_TYPE
, ATTRS.ATTR_GROUP_NAME ATTR_GROUP_NAME
, USGS.ATTR_ID ATTR_ID
, ATTRS.ATTR_NAME ATTR_NAME
, ATTRS.ATTR_DISPLAY_NAME ATTR_DISPLAY_NAME
, USGS.APPLICATION_ID USAGE_APPLICATION_ID
, APPS.APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
, APPS.APPLICATION_NAME APPLICATION_NAME
, USGS.ENABLED_FLAG ENABLED_FLAG
FROM EGO_ITMATTR_APPL_USGS_B USGS
, EGO_ATTRS_V ATTRS
, FND_APPLICATION_VL APPS
WHERE ATTRS.ATTR_ID = USGS.ATTR_ID
AND APPS.APPLICATION_ID = USGS.APPLICATION_ID

Columns