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: IGI.IGI_DUN_TEMP

Object Details

Object Name:	IGI_DUN_TEMP
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_DUN_TEMP
Subobject Name:
Status:	VALID

IGI_DUN_TEMP is a temporary table that stores transaction processing
information for overdue invoices where dunning charges are to be
applied. This is used in the generation of dunning charges.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
CUSTOMER_ID	NUMBER		Customer identifier
NO_OF_INV	NUMBER		Stores customer number assigned to customer by users
CURRENCY_CODE	VARCHAR2	(15)	Transaction currency codes
DUNNING_CHARGE	NUMBER	(15)	Charge defined for customer site
SITE_USE_ID	NUMBER	(15)	Site use identifier of customer site

Query Text

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


SELECT CUSTOMER_ID
,      NO_OF_INV
,      CURRENCY_CODE
,      DUNNING_CHARGE
,      SITE_USE_ID
FROM IGI.IGI_DUN_TEMP;

Dependencies

[top of page]

IGI.IGI_DUN_TEMP does not reference any database object

IGI.IGI_DUN_TEMP is referenced by following:

APPS: IGI_DUN_TEMP