[Home] [Help] [Dependency Information]
Object Name: | FTE_INTERFACE_LANES |
---|---|
Object Type: | TABLE |
Owner: | FTE |
FND Design Data: | FTE.FTE_INTERFACE_LANES |
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_LANES_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | HASH_VALUE |
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 |
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;
FTE.FTE_INTERFACE_LANES does not reference any database object
FTE.FTE_INTERFACE_LANES is referenced by following:
|
|
|