VIEW: APPS.EGO_ITMATTR_APPL_USGS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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