[Home] [Help]
[Dependency Information]
Object Name: | VEA_PARAMETER_MAPPINGS |
---|---|
Object Type: | TABLE |
Owner: | VEA |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
the VEA_PARAMETER_MAPPINGS table contains information about mapping between
- Parameters of base layer program unit
- Parameters of trading partner selector program unit.
It specifies IN/IN OUT parameters of base layer program units which will be passed to IN/IN OUT parameters of trading partner selector program units when called from the code generated by the architecture.
Layer developers specify the mapping using layer workbench while selecting a trading partner selector for a base layer program unit and generate utility derive exact calling syntax for trading partner selector program units using this information.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
VEA_PARAMETER_MAPPINGS_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() |
VEA_PARAMETER_MAPPINGS_U2 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARAMETER_MAPPING_ID | NUMBER | Yes | Parameter mapping identifier | |
LAYER_PROVIDER_CODE | VARCHAR2 | (30) | Yes | Layer developer identifier |
LAYER_HEADER_ID | NUMBER | Yes | Layer header identifier | |
TPS_PARAMETER_ID | NUMBER | Yes | Parameter identifier for trading partner selector program unit | |
TPS_PARAMETER_LP_CODE | VARCHAR2 | (30) | Yes | Layer developer identifier for trading partner selector program unit parameter |
PROGRAM_UNIT_PARAMETER_ID | NUMBER | Yes | Parameter identifier for the base layer program unit | |
PROGRAM_UNIT_PARAM_LP_CODE | VARCHAR2 | (30) | Yes | Layer developer identifier for the base layer program unit parameter |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
REQUEST_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
DESCRIPTION | VARCHAR2 | (1000) | Descriptive text for the parameter mapping |
Cut, paste (and edit) the following text to query this object:
SELECT PARAMETER_MAPPING_ID
, LAYER_PROVIDER_CODE
, LAYER_HEADER_ID
, TPS_PARAMETER_ID
, TPS_PARAMETER_LP_CODE
, PROGRAM_UNIT_PARAMETER_ID
, PROGRAM_UNIT_PARAM_LP_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DESCRIPTION
FROM VEA.VEA_PARAMETER_MAPPINGS;
VEA.VEA_PARAMETER_MAPPINGS does not reference any database object
VEA.VEA_PARAMETER_MAPPINGS is referenced by following:
|
|
|