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

TABLE: FTE.FTE_FACILITY_CARRIERS

Object Details
Object Name: FTE_FACILITY_CARRIERS
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.FTE_FACILITY_CARRIERS
Subobject Name:
Status: VALID


Stores the data for the association between a Facility location and a Carrier.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_FACILITY_CARRIERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID
ColumnCARRIER_ID
Columns
Name Datatype Length Mandatory Comments
LOCATION_ID NUMBER
Yes Location Identifier
CARRIER_ID NUMBER
Yes Carrier Identifier
USAGE_TYPE VARCHAR2 (30) Yes Usage Type of the Facility for the specified carrier. Current default value is "Drop Trailer"
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
PROGRAM_APPLICATION_ID NUMBER

Standard WHO Column
PROGRAM_ID NUMBER

Standard WHO Column
PROGRAM_UPDATE_DATE DATE

Standard WHO Column
REQUEST_ID NUMBER

Standard WHO Column
Query Text

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


SELECT LOCATION_ID
,      CARRIER_ID
,      USAGE_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM FTE.FTE_FACILITY_CARRIERS;

Dependencies

[top of page]

FTE.FTE_FACILITY_CARRIERS does not reference any database object

FTE.FTE_FACILITY_CARRIERS is referenced by following:

SchemaAPPS
SynonymFTE_FACILITY_CARRIERS