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

TABLE: FTE.FTE_LANE_GROUP_COMPONENTS

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


Details table that holds the lane components of a lane group


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_LANE_GROUP_COMPONENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLANE_GROUP_ID
FTE_LANE_GROUP_COMPONENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLANE_ID
FTE_LANE_GROUP_COMPONENTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDESTINATION_ID
ColumnORIGIN_ID
Columns
Name Datatype Length Mandatory Comments
LANE_GROUP_ID NUMBER
Yes LANE_GROUP_ID references FTE_LANE_GROUPS which indicates which lane group this lane belongs to
LANE_ID NUMBER
Yes LANE_ID references FTE_LANES, indicates the lane that belongs to the lane group
ORIGIN_ID NUMBER

Origin ID of the lane
DESTINATION_ID NUMBER

Destination ID of the lane
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
Query Text

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


SELECT LANE_GROUP_ID
,      LANE_ID
,      ORIGIN_ID
,      DESTINATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FTE.FTE_LANE_GROUP_COMPONENTS;

Dependencies

[top of page]

FTE.FTE_LANE_GROUP_COMPONENTS does not reference any database object

FTE.FTE_LANE_GROUP_COMPONENTS is referenced by following:

SchemaFTE
ViewFTE_LANE_GROUP_COMPONENTS#