[Home] [Help] [Dependency Information]
Object Name: | EGO_MAPPINGS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_MAPPINGS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FUNCTION_ID | NUMBER | (15) | Yes | Identifier for the Function whose Parameter is to be mapped (foreign key to EGO_FUNCTIONS_B) |
MAPPED_OBJ_TYPE | VARCHAR2 | (30) | Yes | Lookup indicating whether the Function is a "Prompt", "Visibility", or an "Action" Function |
MAPPED_OBJ_PK1_VAL | VARCHAR2 | (50) | Yes | Identifier for the entity to which the Function is mapped (currently this is always an Action, so it is the Action ID) |
FUNC_PARAM_ID | NUMBER | (15) | Yes | Identifier for the Parameter to be mapped (foreign key to EGO_FUNC_PARAMS_B) |
MAPPED_TO_GROUP_TYPE | VARCHAR2 | (30) | Lookup indicating whether the Parameter is mapped to an Attribute Group value, an Object Primary Key value, or another of the Object attribute values | |
MAPPED_TO_GROUP_PK1 | VARCHAR2 | (50) | First Primary Key for whatever has the values to which the Parameter is mapped (i.e., either the Object or Attribute Group) | |
MAPPED_TO_GROUP_PK2 | VARCHAR2 | (50) | Second Primary Key for whatever has the values to which the Parameter is mapped (i.e., either the Object or Attribute Group) | |
MAPPED_TO_GROUP_PK3 | VARCHAR2 | (50) | Third Primary Key for whatever has the values to which the Parameter is mapped (i.e., either the Object or Attribute Group) | |
MAPPED_ATTRIBUTE | VARCHAR2 | (50) | Name of whatever will supply the Parameter its value (i.e., the Attribute Group Attribute, Object Primary Key, or other Object attribute) | |
MAPPED_TO_GROUP_MEANING | VARCHAR2 | (80) | Yes | Holds, whether the parameter is mapped is to an attribute group or a primary key |
MAPPED_UOM_PARAMETER | NUMBER | (15) | Holds the parameter in the function mapped for getting the UOM value | |
VALUE_UOM_SOURCE | VARCHAR2 | (1) | Determines the source of UOM value for the mapping (user entered/fixed etc.) | |
VALUE_UOM_SOURCE_MEANING | VARCHAR2 | (80) | Determines the source of UOM value for the mapping (user entered/fixed etc.) | |
FIXED_UOM | VARCHAR2 | (3) | Holds the value of the UOM to be passed in for the attribute mapped |
Cut, paste (and edit) the following text to query this object:
SELECT FUNCTION_ID
, MAPPED_OBJ_TYPE
, MAPPED_OBJ_PK1_VAL
, FUNC_PARAM_ID
, MAPPED_TO_GROUP_TYPE
, MAPPED_TO_GROUP_PK1
, MAPPED_TO_GROUP_PK2
, MAPPED_TO_GROUP_PK3
, MAPPED_ATTRIBUTE
, MAPPED_TO_GROUP_MEANING
, MAPPED_UOM_PARAMETER
, VALUE_UOM_SOURCE
, VALUE_UOM_SOURCE_MEANING
, FIXED_UOM
FROM APPS.EGO_MAPPINGS_V;
APPS.EGO_MAPPINGS_V is not referenced by any database object
|
|
|