DBA Data[Home] [Help] [Dependency Information]

TABLE: FTE.FTE_INTERFACE_LANES

Object Details
Object Name: FTE_INTERFACE_LANES
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.FTE_INTERFACE_LANES
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_INTERFACE_LANES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnHASH_VALUE
Columns
Name Datatype Length Mandatory Comments
ORIGIN_NAME VARCHAR2 (25)
Origin Name
DEST_NAME VARCHAR2 (25)
Destination Name
RATE_CHART_STRING VARCHAR2 (4000)
Concatenation of price breaks value
RATE_CHART_NAME VARCHAR2 (40)
Rate Chart Name
HASH_VALUE NUMBER

Hash Value for RATE_CHART_STRING
CLASS_STRING VARCHAR2 (200)
Concatenatin (comma delimited) of Freight Class values
MIN_CHARGE1 VARCHAR2 (10)
Minimun Charge Value
LOAD_ID NUMBER

Load ID of the uploading process
ORIGIN_ID NUMBER

Origin ID associated with Origin Name
DEST_ID NUMBER

Dest ID associated with Destination Name
OWNER_ID NUMBER

Owner ID of the Lane
PROCESS_ID NUMBER

Foreign key from QP_INTERFACE_LIST_HEADERS
GROUP_PROCESS_ID NUMBER

Group process id into multiple parallel process
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORIGIN_NAME
,      DEST_NAME
,      RATE_CHART_STRING
,      RATE_CHART_NAME
,      HASH_VALUE
,      CLASS_STRING
,      MIN_CHARGE1
,      LOAD_ID
,      ORIGIN_ID
,      DEST_ID
,      OWNER_ID
,      PROCESS_ID
,      GROUP_PROCESS_ID
FROM FTE.FTE_INTERFACE_LANES;

Dependencies

[top of page]

FTE.FTE_INTERFACE_LANES does not reference any database object

FTE.FTE_INTERFACE_LANES is referenced by following:

SchemaFTE
ViewFTE_INTERFACE_LANES#