[Home] [Help] [Dependency Information]
Object Name: | FTE_INTERFACE_ZONES |
---|---|
Object Type: | TABLE |
Owner: | FTE |
FND Design Data: | FTE.FTE_INTERFACE_ZONES |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FTE_INTERFACE_ZONES_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | HASH_VALUE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ZONE_NAME | VARCHAR2 | (25) | Zone Name | |
POSTAL_CODE_FROM | VARCHAR2 | (15) | Postal Code from | |
POSTAL_CODE_TO | VARCHAR2 | (15) | Postal Code To | |
POSTAL_CODE_STRING | VARCHAR2 | (4000) | Concatenation of Postal Code ranges | |
LOAD_ID | NUMBER | Origin ID associated with Origin Name | ||
HASH_VALUE | NUMBER | Hash Value for POSTAL_CODE_STRING | ||
ZONE_ID | NUMBER | Zone ID of Zone Name | ||
OWNER_ID | NUMBER | Owner ID of the Zone | ||
ROW_NUMBER | NUMBER | ROw Number |
Cut, paste (and edit) the following text to query this object:
SELECT ZONE_NAME
, POSTAL_CODE_FROM
, POSTAL_CODE_TO
, POSTAL_CODE_STRING
, LOAD_ID
, HASH_VALUE
, ZONE_ID
, OWNER_ID
, ROW_NUMBER
FROM FTE.FTE_INTERFACE_ZONES;
FTE.FTE_INTERFACE_ZONES does not reference any database object
FTE.FTE_INTERFACE_ZONES is referenced by following:
|
|
|