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

VIEW: FTE.FTE_SCHEDULES#

Object Details
Object Name: FTE_SCHEDULES#
Object Type: VIEW
Owner: FTE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHEDULES_ID NUMBER
Yes
LANE_ID NUMBER
Yes
LANE_NUMBER VARCHAR2 (30)
VESSEL_TYPE VARCHAR2 (100)
VESSEL_NAME VARCHAR2 (30)
VOYAGE_NUMBER VARCHAR2 (30)
DEPARTURE_DATE DATE

DEPARTURE_TIME VARCHAR2 (10)
ARRIVAL_DATE DATE

ARRIVAL_TIME VARCHAR2 (10)
ARRIVAL_DATE_INDICATOR NUMBER

FREQUENCY_TYPE VARCHAR2 (10)
FREQUENCY NUMBER

FREQUENCY_ARRIVAL VARCHAR2 (30)
TRANSIT_TIME NUMBER

TRANSIT_TIME_UOM VARCHAR2 (3)
PORT_OF_LOADING VARCHAR2 (240)
PORT_OF_DISCHARGE VARCHAR2 (240)
EFFECTIVE_DATE DATE

EXPIRY_DATE DATE

EDITABLE_FLAG VARCHAR2 (1)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

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# references the following:

SchemaFTE
TableFTE_SCHEDULES
FTE.FTE_SCHEDULES# is referenced by following:

SchemaAPPS
SynonymFTE_SCHEDULES