[Home] [Help] [Dependency Information]
Object Name: | VEA_LAYER_LICENSES |
---|---|
Object Type: | TABLE |
Owner: | VEA |
FND Design Data: | VEA.VEA_LAYER_LICENSES |
Subobject Name: | |
Status: | VALID |
The VEA_LAYER_LICENSES table contains information about customers licensed to use trading partner layers.
Layer developers can licenses trading partner layers to customers using the layer workbench and layer manage utility uses the license information to install layers only for licensed customers.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
VEA_LAYER_LICENSES_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
LAYER_PROVIDER_CODE
TP_LAYER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAYER_PROVIDER_CODE | VARCHAR2 | (500) | Yes | Layer developer identifier |
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 | ||
CUSTOMER_NAME | VARCHAR2 | (100) | Name of the customer licensed to the trading partner layer | |
DESCRIPTION | VARCHAR2 | (1000) | License description | |
TP_LAYER_ID | NUMBER | Trading partner layer identifier |
Cut, paste (and edit) the following text to query this object:
SELECT LAYER_PROVIDER_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CUSTOMER_NAME
, DESCRIPTION
, TP_LAYER_ID
FROM VEA.VEA_LAYER_LICENSES;
VEA.VEA_LAYER_LICENSES does not reference any database object
VEA.VEA_LAYER_LICENSES is referenced by following:
|
|
|