[Home] [Help] [Dependency Information]
Object Name: | MTL_ECONOMIC_ZONES_B |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_ECONOMIC_ZONES_B |
Subobject Name: | |
Status: | VALID |
MTL_ECONOMIC_ZONES_B stores information concerning
all the economic zones. This is a base table that contains
one entry for every economic zone. An example of an
economic zone would be EC for European Community.
Each economic zone is uniquely identified by the economic
zone code which is an internal code.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_ECONOMIC_ZONES_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | ZONE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ZONE_CODE | VARCHAR2 | (10) | Yes | 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 ZONE_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM INV.MTL_ECONOMIC_ZONES_B;
INV.MTL_ECONOMIC_ZONES_B does not reference any database object
INV.MTL_ECONOMIC_ZONES_B is referenced by following:
|
|
|