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_INVOICE_LINES

Object Details

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

Table to store invoice line information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_INVOICE_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_LINE_ID
FTE_INVOICE_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_HEADER_ID
FTE_INVOICE_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_LINE_NUM
FTE_INVOICE_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_LINE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_LINE_ID	NUMBER		Yes	Invoice line id
INVOICE_HEADER_ID	NUMBER		Yes	Invoice header id
INVOICE_LINE_NUM	VARCHAR2	(30)		Invoice line number
INVOICE_LINE_TYPE	VARCHAR2	(30)		Invoice line type
LADING_QUANTITY	NUMBER			Lading quantity
LADING_UNIT	VARCHAR2	(30)		Lading unit
DESCRIPTION	VARCHAR2	(1000)		Description
FREIGHT_CLASS	VARCHAR2	(30)		Freight class
TOTAL_WEIGHT	NUMBER			Total weight
WEIGHT_UOM	VARCHAR2	(30)		Weight uom
TOTAL_VOLUME	NUMBER			Total volume
VOLUME_UOM	VARCHAR2	(30)		Volume uom
RATE_AMOUNT	NUMBER			Rate amount
RATE_TYPE	VARCHAR2	(30)		Rate type
DISCOUNT_UOM	VARCHAR2	(30)		Discount uom
DISCOUNT_AMOUNT	NUMBER			Discount amount
DISCOUNT_TYPE	VARCHAR2	(30)		Discount type
DISCOUNT_DISC	VARCHAR2	(1000)		Discount description
SURCHARGE_UOM	VARCHAR2	(30)		Surcharge uom
SURCHARGE_AMOUNT	NUMBER			Surcharge amount
SURCHARGE_TYPE	VARCHAR2	(30)		Surcharge type
SURCHARGE_DISC	VARCHAR2	(1000)		Surcharge description
APPROVED_AMOUNT	NUMBER			Approved amount on line level
CREATED_BY	NUMBER		Yes	Standard who columns
CREATION_DATE	DATE		Yes	Standard who columns
LAST_UPDATED_BY	NUMBER		Yes	Standard who columns
LAST_UPDATE_DATE	DATE		Yes	Standard who columns
LAST_UPDATE_LOGIN	NUMBER			Standard who columns
RATE_BASIS	VARCHAR2	(50)		Rate basis
RATE_BASIS_UOM	VARCHAR2	(50)		Rate basis uom

Query Text

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


SELECT INVOICE_LINE_ID
,      INVOICE_HEADER_ID
,      INVOICE_LINE_NUM
,      INVOICE_LINE_TYPE
,      LADING_QUANTITY
,      LADING_UNIT
,      DESCRIPTION
,      FREIGHT_CLASS
,      TOTAL_WEIGHT
,      WEIGHT_UOM
,      TOTAL_VOLUME
,      VOLUME_UOM
,      RATE_AMOUNT
,      RATE_TYPE
,      DISCOUNT_UOM
,      DISCOUNT_AMOUNT
,      DISCOUNT_TYPE
,      DISCOUNT_DISC
,      SURCHARGE_UOM
,      SURCHARGE_AMOUNT
,      SURCHARGE_TYPE
,      SURCHARGE_DISC
,      APPROVED_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RATE_BASIS
,      RATE_BASIS_UOM
FROM FTE.FTE_INVOICE_LINES;

Dependencies

[top of page]

FTE.FTE_INVOICE_LINES does not reference any database object

FTE.FTE_INVOICE_LINES is referenced by following:

APPS: FTE_INVOICE_LINES