[Home] [Help] [Dependency Information]
Object Name: | EGO_CATG_MAP_HDRS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_CATG_MAP_HDRS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
View EGO_CATG_MAP_HDRS_VL provides all the information (including translatable information) for Category Mappings. Each row in the view contains a mapping (name, description), and relationship between mapped category sets (e.g. source and target)
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Id | |
CATG_MAP_ID | NUMBER | (15) | Yes | Identifier for the Category Mapping Set |
SOURCE_CATG_SET_ID | NUMBER | (15) | Yes | Identifier for the Source Category Set |
TARGET_CATG_SET_ID | NUMBER | (15) | Yes | Identifier for the Target Category Set |
ENABLED_FLAG | VARCHAR2 | (1) | Whether the Mapping Set is Enabled or Disabled | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
CATG_MAP_NAME | VARCHAR2 | (60) | Yes | Name of the Category Mapping Set |
CATG_MAP_DESC | VARCHAR2 | (320) | A brief description of the Category Mapping Set |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CATG_MAP_ID
, SOURCE_CATG_SET_ID
, TARGET_CATG_SET_ID
, ENABLED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CATG_MAP_NAME
, CATG_MAP_DESC
FROM APPS.EGO_CATG_MAP_HDRS_VL;
APPS.EGO_CATG_MAP_HDRS_VL is not referenced by any database object
|
|
|