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: ISC.ISC_DBI_FTE_INVOICES_F

Object Details

Object Name:	ISC_DBI_FTE_INVOICES_F
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

Base summary table for Transportation Management page. It is built on FTE_INVOICE_HEADERS table. It contains the following dimensions: carrier, mode of transport, service level and time. It contains the following amounts in the global (primary and secondary) currency: billed amount, approved amount, among other invoice header-level information.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_DBI_FTE_INVOICES_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	INVOICE_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_HEADER_ID	NUMBER		Yes	Primary key to identify invoice header
CARRIER_ID	NUMBER			Freight carrier identifier
MODE_OF_TRANSPORT	VARCHAR2	(80)		Mode of transport identifier
ORG_ID	NUMBER			Operating unit identifier
SERVICE_LEVEL	VARCHAR2	(80)		Service level identifier
SUPPLIER_ID	NUMBER			Supplier identifier
APPROVED_AMT_F	NUMBER			Approved amount in functional currency
APPROVED_AMT_G	NUMBER			Approved amount in primary global currency
APPROVED_AMT_G1	NUMBER			Approved amount in secondary global currency
BILL_AMT_F	NUMBER			Bill amount in functional currency
BILL_AMT_G	NUMBER			Bill amount in primary global currency
BILL_AMT_G1	NUMBER			Bill amount in secondary global currency
BILL_NUMBER	VARCHAR2	(80)		Bill number
BILL_STATUS	VARCHAR2	(80)		Bill status
BILL_TYPE	VARCHAR2	(80)		Bill type
BOL	VARCHAR2	(80)		Bill of lading number
DELIVERY_LEG_ID	NUMBER			Delivery leg identifier
TRIP_ID	NUMBER			Trip identifier
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
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 INVOICE_HEADER_ID
,      CARRIER_ID
,      MODE_OF_TRANSPORT
,      ORG_ID
,      SERVICE_LEVEL
,      SUPPLIER_ID
,      APPROVED_AMT_F
,      APPROVED_AMT_G
,      APPROVED_AMT_G1
,      BILL_AMT_F
,      BILL_AMT_G
,      BILL_AMT_G1
,      BILL_NUMBER
,      BILL_STATUS
,      BILL_TYPE
,      BOL
,      DELIVERY_LEG_ID
,      TRIP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM ISC.ISC_DBI_FTE_INVOICES_F;

Dependencies

[top of page]

ISC.ISC_DBI_FTE_INVOICES_F does not reference any database object

ISC.ISC_DBI_FTE_INVOICES_F is referenced by following:

APPS: ISC_DBI_FTE_INVOICES_F; ISC_TRN_003_MV; ISC_TRN_004_MV