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_TMP_FTE_INVOICES

Object Details

Object Name:	ISC_DBI_TMP_FTE_INVOICES
Object Type:	TABLE
Owner:	ISC
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_INTERFACE
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_DBI_TMP_FTE_INVOICES_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	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_TRX	NUMBER			Approved amount for transaction
BATCH_ID	NUMBER			Batch identifier
BILL_AMT_TRX	NUMBER			Bill amount for transaction
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
CONVERSION_DATE	DATE			Currency conversion date
CONVERSION_TYPE_CODE	VARCHAR2	(80)		Currency conversion type
DELIVERY_LEG_ID	NUMBER			Delivery leg identifier
TRIP_ID	NUMBER			Trip identifier
TRX_CURRENCY_CODE	VARCHAR2	(30)		Transactional currency code
WH_CURRENCY_CODE	VARCHAR2	(30)		Warehouse currency code

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_TRX
,      BATCH_ID
,      BILL_AMT_TRX
,      BILL_NUMBER
,      BILL_STATUS
,      BILL_TYPE
,      BOL
,      CONVERSION_DATE
,      CONVERSION_TYPE_CODE
,      DELIVERY_LEG_ID
,      TRIP_ID
,      TRX_CURRENCY_CODE
,      WH_CURRENCY_CODE
FROM ISC.ISC_DBI_TMP_FTE_INVOICES;

Dependencies

[top of page]

ISC.ISC_DBI_TMP_FTE_INVOICES does not reference any database object

ISC.ISC_DBI_TMP_FTE_INVOICES is referenced by following:

APPS: ISC_DBI_TMP_FTE_INVOICES