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_SCHEDULES

Object Details

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

FTE_SCHEDULES stores schedule information for each lane. Schedules define time-bound information for each lane and include departure and arrival dates and times, voyage numbers, Port of Loading, and Port of Discharge. Two types of schedules are supported in this table - date based and frequency based. Frequency based schedules have only time of day and an associated Frequency column. Schedules have a range of effectivity defined by Effective Date and Expiry Date.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_SCHEDULES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SCHEDULES_ID
FTE_SCHEDULES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SCHEDULES_ID	NUMBER		Yes	Primary key
LANE_ID	NUMBER		Yes	Foreign key for FTE_LANES
LANE_NUMBER	VARCHAR2	(30)		Lane reference number
VESSEL_TYPE	VARCHAR2	(100)		Vessel Type
VESSEL_NAME	VARCHAR2	(30)		Vessel name
VOYAGE_NUMBER	VARCHAR2	(30)		Number or name of voyage
DEPARTURE_DATE	DATE			Date of departure
DEPARTURE_TIME	VARCHAR2	(10)		Time of departure
ARRIVAL_DATE	DATE			Date of arrival
ARRIVAL_TIME	VARCHAR2	(10)		Time of arrival
ARRIVAL_DATE_INDICATOR	NUMBER			Difference of ays between Departure and Arrival date. It used for frequency based schedules.
FREQUENCY_TYPE	VARCHAR2	(10)		Type of Frequency of the schedule. Could be Daily, Weekly or null.
FREQUENCY	NUMBER			Frequency of the schedule
FREQUENCY_ARRIVAL	VARCHAR2	(30)		Arrival of Frequency
TRANSIT_TIME	NUMBER			Number of hours/days between departure and arrival
TRANSIT_TIME_UOM	VARCHAR2	(3)		Unit of Measure of Transit Time
PORT_OF_LOADING	VARCHAR2	(240)		Port of loading
PORT_OF_DISCHARGE	VARCHAR2	(240)		Port of discharge
EFFECTIVE_DATE	DATE			Effective date for the schedule
EXPIRY_DATE	DATE			Expiry date for the schedule
EDITABLE_FLAG	VARCHAR2	(1)		Editable Flag for the internal use only
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column

Query Text

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


SELECT SCHEDULES_ID
,      LANE_ID
,      LANE_NUMBER
,      VESSEL_TYPE
,      VESSEL_NAME
,      VOYAGE_NUMBER
,      DEPARTURE_DATE
,      DEPARTURE_TIME
,      ARRIVAL_DATE
,      ARRIVAL_TIME
,      ARRIVAL_DATE_INDICATOR
,      FREQUENCY_TYPE
,      FREQUENCY
,      FREQUENCY_ARRIVAL
,      TRANSIT_TIME
,      TRANSIT_TIME_UOM
,      PORT_OF_LOADING
,      PORT_OF_DISCHARGE
,      EFFECTIVE_DATE
,      EXPIRY_DATE
,      EDITABLE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM FTE.FTE_SCHEDULES;

Dependencies

[top of page]

FTE.FTE_SCHEDULES does not reference any database object

FTE.FTE_SCHEDULES is referenced by following:

APPS: FTE_SCHEDULES