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

TABLE: FTE.FTE_LANE_COMMODITIES

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


FTE_LANE_COMMODITIES stores commodities that are supported for transportation on a given lane. Commodity Type and Commodity Code are obtained from Meaning and Lookup Code for commodities lookup type FTE_COMMODITIES stored in FND_LOOKUPS. Price basis(Weight, Volume, or Container) is also stored for each commodity in this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_LANE_COMMODITIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLANE_ID
Columns
Name Datatype Length Mandatory Comments
LANE_COMMODITY_ID NUMBER
Yes Lane Commodity Identifier
LANE_ID NUMBER
Yes Foreign key for FTE_LANES
BASIS VARCHAR2 (30)
Basis for commodity. Define a price basis on commodity level.
COMMODITY_CATG_ID NUMBER
Yes Commodity Category Identifier
CREATED_BY NUMBER
Yes Who column
CREATION_DATE DATE
Yes Who column
LAST_UPDATED_BY NUMBER
Yes Who column
LAST_UPDATE_DATE DATE
Yes Who column
LAST_UPDATE_LOGIN NUMBER

Who column
Query Text

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


SELECT LANE_COMMODITY_ID
,      LANE_ID
,      BASIS
,      COMMODITY_CATG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM FTE.FTE_LANE_COMMODITIES;

Dependencies

[top of page]

FTE.FTE_LANE_COMMODITIES does not reference any database object

FTE.FTE_LANE_COMMODITIES is referenced by following:

SchemaFTE
ViewFTE_LANE_COMMODITIES#