DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.EGO_ITMATTR_APPL_USGS_V

Object Details
Object Name: EGO_ITMATTR_APPL_USGS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEGO.EGO_ITMATTR_APPL_USGS_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
ATTR_GROUP_ID NUMBER (10) Yes The attribute group ID of the associated item attribute.
ATTR_GROUP_APPLICATION_ID NUMBER (10) Yes Application Id
ATTR_GROUP_TYPE VARCHAR2 (40) Yes Attribute group type
ATTR_GROUP_NAME VARCHAR2 (30) Yes Attribute group internal name
ATTR_ID NUMBER (15) Yes Attribute identifier
ATTR_NAME VARCHAR2 (30) Yes Attribute internal name
ATTR_DISPLAY_NAME VARCHAR2 (80) Yes Attribute display name
USAGE_APPLICATION_ID NUMBER (3) Yes The application for which a particular item attribute is enabled.
APPLICATION_SHORT_NAME VARCHAR2 (50) Yes Application short name
APPLICATION_NAME VARCHAR2 (240) Yes Application name
ENABLED_FLAG VARCHAR2 (1)
This column determines whether an application-attribute association is enabled or not; associations are not to be deleted.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ATTR_GROUP_ID
,      ATTR_GROUP_APPLICATION_ID
,      ATTR_GROUP_TYPE
,      ATTR_GROUP_NAME
,      ATTR_ID
,      ATTR_NAME
,      ATTR_DISPLAY_NAME
,      USAGE_APPLICATION_ID
,      APPLICATION_SHORT_NAME
,      APPLICATION_NAME
,      ENABLED_FLAG
FROM APPS.EGO_ITMATTR_APPL_USGS_V;

Dependencies

[top of page]

APPS.EGO_ITMATTR_APPL_USGS_V references the following:

SchemaAPPS
ViewEGO_ATTRS_V
SynonymEGO_ITMATTR_APPL_USGS_B
ViewFND_APPLICATION_VL

APPS.EGO_ITMATTR_APPL_USGS_V is not referenced by any database object