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_LAYER_HEADERS

Object Details

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

The VEA_LAYER_HEADERS table contains information about
- how base layer program units are linked with callout program units
- Which trading partner selector program unit is to be executed to derive the branch criteria
Layer developers or customers specify this information using layer workbench and it is used by generate utility to generate code for calling callout program units and trading partner selector program units.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
VEA_LAYER_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_SEED	LAYER_PROVIDER_CODE LAYER_HEADER_ID
VEA_LAYER_HEADERS_U2	NORMAL	UNIQUE	APPS_TS_SEED	LAYER_PROVIDER_CODE PROGRAM_UNIT_ID PROGRAM_UNIT_LP_CODE CONDITION_TYPE
VEA_LAYER_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	PROGRAM_UNIT_ID PROGRAM_UNIT_LP_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
LAYER_HEADER_ID	NUMBER		Yes	Layer header identifier
LAYER_PROVIDER_CODE	VARCHAR2	(30)	Yes	Layer developer identifier
PROGRAM_UNIT_ID	NUMBER		Yes	Program unit identifier
PROGRAM_UNIT_LP_CODE	VARCHAR2	(30)	Yes	Layer developer identifier for program unit
TPS_PROGRAM_UNIT_ID	NUMBER		Yes	Trading partner selector program unit identifier
TPS_PROGRAM_UNIT_LP_CODE	VARCHAR2	(30)	Yes	Layer developer identifier for Trading partner selector 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
CONDITION_TYPE	VARCHAR2	(1)		Indicates whether callout is before(B) or after(A) the base layer program unit
DESCRIPTION	VARCHAR2	(1000)		Descriptive text for the header information

Query Text

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


SELECT LAYER_HEADER_ID
,      LAYER_PROVIDER_CODE
,      PROGRAM_UNIT_ID
,      PROGRAM_UNIT_LP_CODE
,      TPS_PROGRAM_UNIT_ID
,      TPS_PROGRAM_UNIT_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
,      CONDITION_TYPE
,      DESCRIPTION
FROM VEA.VEA_LAYER_HEADERS;

Dependencies

[top of page]

VEA.VEA_LAYER_HEADERS does not reference any database object

VEA.VEA_LAYER_HEADERS is referenced by following:

APPS: VEA_LAYER_HEADERS