eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FTE.FTE_FREIGHT_COSTS_TEMP

Object Details

Object Name:	FTE_FREIGHT_COSTS_TEMP
Object Type:	TABLE
Owner:	FTE
FND Design Data:	FTE.FTE_FREIGHT_COSTS_TEMP
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_FREIGHT_COSTS_TEMP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPARISON_REQUEST_ID FREIGHT_COST_ID
FTE_FREIGHT_COSTS_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_ID
FTE_FREIGHT_COSTS_TEMP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_DETAIL_ID
FTE_FREIGHT_COSTS_TEMP_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANE_ID
FTE_FREIGHT_COSTS_TEMP_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SCHEDULE_ID
FTE_FREIGHT_COSTS_TEMP_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VEHICLE_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FREIGHT_COST_ID	NUMBER		Yes	primary key
FREIGHT_COST_TYPE_ID	NUMBER		Yes	FK to WSH_FREIGHT_COST_TYPES
UNIT_AMOUNT	NUMBER			unit_amount
CALCULATION_METHOD	VARCHAR2	(15)		calculation method
UOM	VARCHAR2	(15)		unit of measure
QUANTITY	NUMBER			quantity
TOTAL_AMOUNT	NUMBER			total amount
CURRENCY_CODE	VARCHAR2	(15)		currency code
CONVERSION_DATE	DATE			conversion date
CONVERSION_RATE	NUMBER			conversion rate
CONVERSION_TYPE_CODE	VARCHAR2	(30)		conversion type code
TRIP_ID	NUMBER			trip id
STOP_ID	NUMBER			stop id
DELIVERY_ID	NUMBER			delivery id
DELIVERY_LEG_ID	NUMBER			delivery leg id
DELIVERY_DETAIL_ID	NUMBER			delivery detail id
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		flexfield attribute category
ATTRIBUTE1	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE2	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE3	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE4	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE5	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE6	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE7	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE8	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE9	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE10	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE11	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE12	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE13	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE14	VARCHAR2	(150)		flexfield attribute
ATTRIBUTE15	VARCHAR2	(150)		flexfield attribute
CREATION_DATE	DATE		Yes	creation_date
CREATED_BY	NUMBER		Yes	created by
LAST_UPDATE_DATE	DATE		Yes	last update date
LAST_UPDATED_BY	NUMBER		Yes	last updated by
LAST_UPDATE_LOGIN	NUMBER			last update login
PROGRAM_APPLICATION_ID	NUMBER			program application id
PROGRAM_ID	NUMBER			program id
PROGRAM_UPDATE_DATE	DATE			program update date
REQUEST_ID	NUMBER			request id
FREIGHT_CODE	VARCHAR2	(30)		freight code
LINE_TYPE_CODE	VARCHAR2	(30)		identifies type of cost
PRICING_LIST_HEADER_ID	NUMBER			FK to QP_LIST_HEADERS_B
PRICING_LIST_LINE_ID	NUMBER			FK to QP_LIST_LINES
APPLIED_TO_CHARGE_ID	NUMBER			FK to FTE_FREIGHT_COSTS_TEMP
CHARGE_UNIT_VALUE	NUMBER			charge unit value
CHARGE_SOURCE_CODE	VARCHAR2	(30)		charge source code
ESTIMATED_FLAG	VARCHAR2	(1)		identifies an estimate row
COMPARISON_REQUEST_ID	NUMBER		Yes	handle to a comparison request
LANE_ID	NUMBER			FK to FTE_LANES
SCHEDULE_ID	NUMBER			FK to FTE_SCHEDULES
MOVED_TO_MAIN_FLAG	VARCHAR2	(1)		indicates if row has been copied to main table
SERVICE_TYPE_CODE	VARCHAR2	(30)		service type
COMMODITY_CATEGORY_ID	NUMBER			Identifier in MTL_CATEGORIES to store the commodity classification
VEHICLE_TYPE_ID	NUMBER
BILLABLE_QUANTITY	NUMBER
BILLABLE_UOM	VARCHAR2	(15)
BILLABLE_BASIS	VARCHAR2	(30)

Query Text

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


SELECT FREIGHT_COST_ID
,      FREIGHT_COST_TYPE_ID
,      UNIT_AMOUNT
,      CALCULATION_METHOD
,      UOM
,      QUANTITY
,      TOTAL_AMOUNT
,      CURRENCY_CODE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CONVERSION_TYPE_CODE
,      TRIP_ID
,      STOP_ID
,      DELIVERY_ID
,      DELIVERY_LEG_ID
,      DELIVERY_DETAIL_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      FREIGHT_CODE
,      LINE_TYPE_CODE
,      PRICING_LIST_HEADER_ID
,      PRICING_LIST_LINE_ID
,      APPLIED_TO_CHARGE_ID
,      CHARGE_UNIT_VALUE
,      CHARGE_SOURCE_CODE
,      ESTIMATED_FLAG
,      COMPARISON_REQUEST_ID
,      LANE_ID
,      SCHEDULE_ID
,      MOVED_TO_MAIN_FLAG
,      SERVICE_TYPE_CODE
,      COMMODITY_CATEGORY_ID
,      VEHICLE_TYPE_ID
,      BILLABLE_QUANTITY
,      BILLABLE_UOM
,      BILLABLE_BASIS
FROM FTE.FTE_FREIGHT_COSTS_TEMP;

Dependencies

[top of page]

FTE.FTE_FREIGHT_COSTS_TEMP does not reference any database object

FTE.FTE_FREIGHT_COSTS_TEMP is referenced by following:

APPS: FTE_FREIGHT_COSTS_TEMP