[Home] [Help] [Dependency Information]
Object Name: | VEA_TP_LAYERS |
---|---|
Object Type: | TABLE |
Owner: | VEA |
FND Design Data: | VEA.VEA_TP_LAYERS |
Subobject Name: | |
Status: | VALID |
The VEA_TP_LAYERS table contains information about trading partner layers. Each row contains information about trading partner layer name, description and whether it is active or inactive.
Layer developers create trading partner layers using layer workbench. Trading partner layers can be made active or inactive using runtime option of the trading partner architecture. Generate utility look at this information to generate code to execute only active layers
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
VEA_TP_LAYERS_U1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
LAYER_PROVIDER_CODE
TP_LAYER_ID |
VEA_TP_LAYERS_U2 | NORMAL | NONUNIQUE | APPS_TS_SEED |
LAYER_PROVIDER_CODE
NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TP_LAYER_ID | NUMBER | Yes | Trading partner layer identifier | |
LAYER_PROVIDER_CODE | VARCHAR2 | (30) | Yes | Layer developer identifier |
NAME | VARCHAR2 | (50) | Yes | Trading partner layer name |
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) | Trading partner layer description | |
ACTIVE_FLAG | VARCHAR2 | (1) | Indicates whether a trading partner layer is active or inactive, Y/N flag |
Cut, paste (and edit) the following text to query this object:
SELECT TP_LAYER_ID
, LAYER_PROVIDER_CODE
, NAME
, 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
FROM VEA.VEA_TP_LAYERS;
VEA.VEA_TP_LAYERS does not reference any database object
VEA.VEA_TP_LAYERS is referenced by following:
|
|
|