eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FTE.FTE_LANES

Object Details

Object Name:	FTE_LANES
Object Type:	TABLE
Owner:	FTE
FND Design Data:	FTE.FTE_LANES
Subobject Name:
Status:	VALID

FTE_LANES stores services catalog lane descriptions.. Lanes have primary columns of Origin, Destination, Mode of transport, and Carrier and store descriptors for commodities, equipments and services. Each lane is assigned a Lane Number unique for a given Carrier.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_LANES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LANE_ID
FTE_LANES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIGIN_ID DESTINATION_ID
FTE_LANES_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CARRIER_ID LANE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
LANE_ID	NUMBER		Yes	Primary Key
LANE_NUMBER	VARCHAR2	(30)		Reference to the lane
OWNER_ID	NUMBER		Yes	Ownership Identifier of the Lane
CARRIER_ID	NUMBER		Yes	Foreign key for carrier
ORIGIN_ID	NUMBER		Yes	Foreign key for WSH_REGIONS for origin
DESTINATION_ID	NUMBER		Yes	Foreign key for WSH_REGIONS for destination
MODE_OF_TRANSPORTATION_CODE	VARCHAR2	(30)		Codes for mode of transportatin column
PORT_OF_DISCHARGE	VARCHAR2	(240)		Port of discharge
PORT_OF_LOADING	VARCHAR2	(240)		Port of loading
TRANSIT_TIME	NUMBER			Number of hour or days between departure and arrival
TRANSIT_TIME_UOM	VARCHAR2	(3)		Unit of measure of Transit Time
SPECIAL_HANDLING	VARCHAR2	(2000)		Special handling
ADDITIONAL_INSTRUCTIONS	VARCHAR2	(2000)		Additional Instructions
COMMODITY_DETAIL_FLAG	VARCHAR2	(1)		Commodity Detail Flag for internal use
EQUIPMENT_DETAIL_FLAG	VARCHAR2	(1)		Equipment Detail Flag for internal use
SERVICE_DETAIL_FLAG	VARCHAR2	(1)		Service Detail Flag for internal use
COMM_FC_CLASS_CODE	VARCHAR2	(30)		Commodity or Freight Classification Code
COMMODITY_CATG_ID	NUMBER			Commodity Category Identifier
EQUIPMENT_TYPE_CODE	VARCHAR2	(30)		Equipment Type Code
SERVICE_TYPE_CODE	VARCHAR2	(30)		Service Type Code
DISTANCE	NUMBER			Distance between origin and destination
DISTANCE_UOM	VARCHAR2	(3)		Unit of measure for distance column
SCHEDULES_FLAG	VARCHAR2	(1)		Flag. Value Y :If the lane has schedules
PRICELIST_ID	NUMBER			Foreign key for price tables
PRICELIST_VIEW_FLAG	VARCHAR2	(1)		Price List View flag for internal use only
BASIS	VARCHAR2	(30)		Basis for commodity. Define a price basis on lane level.
EFFECTIVE_DATE	DATE			Start Date of the Lane
EXPIRY_DATE	DATE			End Date of the Lane
EDITABLE_FLAG	VARCHAR2	(1)		Editable Flag for the internal use only
REQUEST_ID	NUMBER			Who column
PROGRAM_APPLICATION_ID	NUMBER			Who column
PROGRAM_ID	NUMBER			Who column
PROGRAM_UPDATE_DATE	DATE			Who column
CREATED_BY	NUMBER		Yes	Who column
CREATION_DATE	DATE		Yes	Who column
LAST_UPDATED_BY	NUMBER		Yes	Who column
LAST_UPDATE_DATE	DATE		Yes	Who column
LAST_UPDATE_LOGIN	NUMBER			Who column
LANE_TYPE	VARCHAR2	(60)		lane type for internal use only
TARIFF_NAME	VARCHAR2	(60)		Tariff Name for LTL Services only

Query Text

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


SELECT LANE_ID
,      LANE_NUMBER
,      OWNER_ID
,      CARRIER_ID
,      ORIGIN_ID
,      DESTINATION_ID
,      MODE_OF_TRANSPORTATION_CODE
,      PORT_OF_DISCHARGE
,      PORT_OF_LOADING
,      TRANSIT_TIME
,      TRANSIT_TIME_UOM
,      SPECIAL_HANDLING
,      ADDITIONAL_INSTRUCTIONS
,      COMMODITY_DETAIL_FLAG
,      EQUIPMENT_DETAIL_FLAG
,      SERVICE_DETAIL_FLAG
,      COMM_FC_CLASS_CODE
,      COMMODITY_CATG_ID
,      EQUIPMENT_TYPE_CODE
,      SERVICE_TYPE_CODE
,      DISTANCE
,      DISTANCE_UOM
,      SCHEDULES_FLAG
,      PRICELIST_ID
,      PRICELIST_VIEW_FLAG
,      BASIS
,      EFFECTIVE_DATE
,      EXPIRY_DATE
,      EDITABLE_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LANE_TYPE
,      TARIFF_NAME
FROM FTE.FTE_LANES;

Dependencies

[top of page]

FTE.FTE_LANES does not reference any database object

FTE.FTE_LANES is referenced by following:

FTE: FTE_LANES#