[Home] [Help] [Dependency Information]
Object Name: | MTL_LE_ECONOMIC_ZONES |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_LE_ECONOMIC_ZONES |
Subobject Name: | |
Status: | VALID |
MTL_LE_ECONOMIC_ZONES is an intersection table. It stores
information concerning the assignment of legal entity to
economic zones. There is one entry in this table for every
legal entity and economic zone.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_LE_ECONOMIC_ZONES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
LEGAL_ENTITY_ID
ZONE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEGAL_ENTITY_ID | NUMBER | Yes | Legal Entity Identifier | |
ZONE_CODE | VARCHAR2 | (10) | Yes | Economic Zone Code |
CREATED_BY | NUMBER | (15) | Yes | standard who column |
CREATION_DATE | DATE | Yes | standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | standard who column |
LAST_UPDATE_DATE | DATE | Yes | standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT LEGAL_ENTITY_ID
, ZONE_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM INV.MTL_LE_ECONOMIC_ZONES;
INV.MTL_LE_ECONOMIC_ZONES does not reference any database object
INV.MTL_LE_ECONOMIC_ZONES is referenced by following:
|
|
|