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_LAYERS

Object Details

Object Name:	VEA_LAYERS
Object Type:	TABLE
Owner:	VEA
FND Design Data:	VEA.VEA_LAYERS
Subobject Name:
Status:	VALID

The VEA_LAYERS table contains information about branches with each base layer program unit.
Each row contains information about
- Which trading partner layer program unit is linked to base layer program unit
- Branching conditions under which trading partner layer program unit is to be called in place of base layer program unit
- Whether branch is active or inactive
Layer developers create branches using layer workbench and generate utility generate code to conditionally execute active branches , that is , trading partner layer program units using this information.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
VEA_LAYERS_U1	NORMAL	UNIQUE	APPS_TS_SEED	LAYER_PROVIDER_CODE LAYER_ID
VEA_LAYERS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	LAYER_HEADER_ID LAYER_PROVIDER_CODE
VEA_LAYERS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	NEW_PROGRAM_UNIT_ID PROGRAM_UNIT_LP_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
LAYER_ID	NUMBER		Yes	Branch identifier
LAYER_PROVIDER_CODE	VARCHAR2	(30)	Yes	Layer developer identifier
LAYER_HEADER_ID	NUMBER		Yes	Layer header identifier
NEW_PROGRAM_UNIT_ID	NUMBER		Yes	Trading partner layer program unit identifier
PROGRAM_UNIT_LP_CODE	VARCHAR2	(30)	Yes	Layer developer identifier for trading partner layer program unit
SEQUENCE_NUMBER	NUMBER		Yes	Sequence of the branch within the base layer program unit
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)		Branch description
ACTIVE_FLAG	VARCHAR2	(1)		Indicates whether branch is active or inactive, Y or N flag
TPS_PARAMETER1_ID	NUMBER			Trading partner selector program unit parameter1 identifier
TPS_PARAMETER1_VALUE	VARCHAR2	(500)		Trading partner selector program unit parameter1 value
TPS_PARAMETER2_ID	NUMBER			Trading partner selector program unit parameter2 identifier
TPS_PARAMETER2_VALUE	VARCHAR2	(500)		Trading partner selector program unit parameter2 value
TPS_PARAMETER3_ID	NUMBER			Trading partner selector program unit parameter3 identifier
TPS_PARAMETER3_VALUE	VARCHAR2	(500)		Trading partner selector program unit parameter3 value
TPS_PARAMETER4_ID	NUMBER			Trading partner selector program unit parameter4 identifier
TPS_PARAMETER4_VALUE	VARCHAR2	(500)		Trading partner selector program unit parameter4 value
TPS_PARAMETER5_ID	NUMBER			Trading partner selector program unit parameter5 identifier
TPS_PARAMETER5_VALUE	VARCHAR2	(500)		Trading partner selector program unit parameter5 value
TPS_PARAMETER6_ID	NUMBER			Trading partner selector program unit parameter6 identifier
TPS_PARAMETER6_VALUE	VARCHAR2	(500)		Trading partner selector program unit parameter6 value
TPS_PARAMETER7_ID	NUMBER			Trading partner selector program unit parameter7 identifier
TPS_PARAMETER7_VALUE	VARCHAR2	(500)		Trading partner selector program unit parameter7 value
TPS_PARAMETER8_ID	NUMBER			Trading partner selector program unit parameter8 identifier
TPS_PARAMETER8_VALUE	VARCHAR2	(500)		Trading partner selector program unit parameter8 value
TPS_PARAMETER9_ID	NUMBER			Trading partner selector program unit parameter9 identifier
TPS_PARAMETER9_VALUE	VARCHAR2	(500)		Trading partner selector program unit parameter9 value
TPS_PARAMETER10_ID	NUMBER			Trading partner selector program unit parameter10 identifier
TPS_PARAMETER10_VALUE	VARCHAR2	(500)		Trading partner selector program unit parameter10 value
EXECUTION_SEQUENCE	NUMBER			Execution Sequence of the branch within the base layer program unit used by customer sites

Query Text

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


SELECT LAYER_ID
,      LAYER_PROVIDER_CODE
,      LAYER_HEADER_ID
,      NEW_PROGRAM_UNIT_ID
,      PROGRAM_UNIT_LP_CODE
,      SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DESCRIPTION
,      ACTIVE_FLAG
,      TPS_PARAMETER1_ID
,      TPS_PARAMETER1_VALUE
,      TPS_PARAMETER2_ID
,      TPS_PARAMETER2_VALUE
,      TPS_PARAMETER3_ID
,      TPS_PARAMETER3_VALUE
,      TPS_PARAMETER4_ID
,      TPS_PARAMETER4_VALUE
,      TPS_PARAMETER5_ID
,      TPS_PARAMETER5_VALUE
,      TPS_PARAMETER6_ID
,      TPS_PARAMETER6_VALUE
,      TPS_PARAMETER7_ID
,      TPS_PARAMETER7_VALUE
,      TPS_PARAMETER8_ID
,      TPS_PARAMETER8_VALUE
,      TPS_PARAMETER9_ID
,      TPS_PARAMETER9_VALUE
,      TPS_PARAMETER10_ID
,      TPS_PARAMETER10_VALUE
,      EXECUTION_SEQUENCE
FROM VEA.VEA_LAYERS;

Dependencies

[top of page]

VEA.VEA_LAYERS does not reference any database object

VEA.VEA_LAYERS is referenced by following:

VEA: VEA_LAYERS#