eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: VEA.VEA_PARAMETER_MAPPINGS

Object Details

Object Name:	VEA_PARAMETER_MAPPINGS
Object Type:	TABLE
Owner:	VEA
FND Design Data:	VEA.VEA_PARAMETER_MAPPINGS
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.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
VEA_PARAMETER_MAPPINGS_U1	NORMAL	UNIQUE	APPS_TS_SEED	LAYER_PROVIDER_CODE PARAMETER_MAPPING_ID
VEA_PARAMETER_MAPPINGS_U2	NORMAL	UNIQUE	APPS_TS_SEED	LAYER_PROVIDER_CODE LAYER_HEADER_ID TPS_PARAMETER_LP_CODE TPS_PARAMETER_ID

Columns

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

Query Text

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;

Dependencies

[top of page]

VEA.VEA_PARAMETER_MAPPINGS does not reference any database object

VEA.VEA_PARAMETER_MAPPINGS is referenced by following:

VEA: VEA_PARAMETER_MAPPINGS#