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

TABLE: FTE.FTE_SCHEDULES

Object Details
Object Name: FTE_SCHEDULES
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_SCHEDULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSCHEDULES_ID
FTE_SCHEDULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLANE_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:

SchemaFTE
ViewFTE_SCHEDULES#