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: IEX.IEX_DUNNINGS

Object Details

Object Name:	IEX_DUNNINGS
Object Type:	TABLE
Owner:	IEX
FND Design Data:	IEX.IEX_DUNNINGS
Subobject Name:
Status:	VALID

Holds data on all dunning transactions sent by the system.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEX_DUNNINGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DUNNING_ID
IEX_DUNNINGS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELINQUENCY_ID
IEX_DUNNINGS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DUNNING_OBJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DUNNING_ID	NUMBER		Yes	Primary key
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
SECURITY_GROUP_ID	NUMBER			Subscriber id, for CRM Online Services use
TEMPLATE_ID	NUMBER			FKey to 1-1fulfillment template. What letter did we send.
DELINQUENCY_ID	NUMBER			FKey to iex_delinquencies_all
STATUS	VARCHAR2	(240)		Status of the dunnin Open or Closed
CALLBACK_YN	VARCHAR2	(1)		Should we callback about this letter?
CALLBACK_DATE	DATE			When will we callback.
CAMPAIGN_SCHED_ID	NUMBER			What marketing campaign are we working on
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
OBJECT_TYPE	VARCHAR2	(30)		What object on JTF_OBJECTS does this dunning reffers to.
OBJECT_ID	NUMBER			ID of the object reffered on OBJECT_TYPE
DUNNING_METHOD	VARCHAR2	(30)		What method did we use to send dunning.
AMOUNT_DUE_REMAINING	NUMBER			Ammount due remaining on the delinquency.
CURRENCY_CODE	VARCHAR2	(15)		Currency code for the amount remaining
DUNNING_OBJECT_ID	NUMBER			What JFT_OBJECT are we sending dunning to.
DUNNING_LEVEL	VARCHAR2	(30)		What dunning level are we using - Customer-Account-Bill_to_site-Delinquency
FFM_REQUEST_ID	NUMBER			Fulfilment server Request ID
FINANCIAL_CHARGE	NUMBER			Amount of the finance charge on this dunning.
LETTER_NAME	VARCHAR2	(30)		Dunning letter name.
INTEREST_AMT	NUMBER			Interest charged in the dunning
XML_REQUEST_ID	NUMBER			ID of the request made to xml publisher
XML_TEMPLATE_ID	NUMBER			ID of the XML publisher template used to create this dunning.
DUNNING_PLAN_ID	NUMBER	(10)		Foreign key to iex_dunning_plans_b
CONTACT_DESTINATION	VARCHAR2	(240)		Contact who received the dunning.
CONTACT_PARTY_ID	NUMBER			ID of the contact who received the dunning.
DELIVERY_STATUS	VARCHAR2	(30)		Delivery Status
PARENT_DUNNING_ID	NUMBER	(15)		Parent Dunning ID
DUNNING_MODE	VARCHAR2	(10)		Dunning mode (possible values Final/Preview)
CONFIRMATION_MODE	VARCHAR2	(10)		Preview Action(possible values Confirmed/Rejected)
ORG_ID	NUMBER			Organization identifier
AG_DN_XREF_ID	NUMBER			Foreign key to AG_DN_XREF_ID table
CORRESPONDENCE_DATE	DATE			Date of the correspondence
ADDT_XML_TEMPLATE_ID	NUMBER			ID of the XML publisher template used to create this dunning.
ADDT_DELIVERY_STATUS	VARCHAR2	(30)		Delivery Status for additional xml templalte
AS_OF_DATE	DATE			As of date of dunning

Query Text

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


SELECT DUNNING_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SECURITY_GROUP_ID
,      TEMPLATE_ID
,      DELINQUENCY_ID
,      STATUS
,      CALLBACK_YN
,      CALLBACK_DATE
,      CAMPAIGN_SCHED_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      OBJECT_TYPE
,      OBJECT_ID
,      DUNNING_METHOD
,      AMOUNT_DUE_REMAINING
,      CURRENCY_CODE
,      DUNNING_OBJECT_ID
,      DUNNING_LEVEL
,      FFM_REQUEST_ID
,      FINANCIAL_CHARGE
,      LETTER_NAME
,      INTEREST_AMT
,      XML_REQUEST_ID
,      XML_TEMPLATE_ID
,      DUNNING_PLAN_ID
,      CONTACT_DESTINATION
,      CONTACT_PARTY_ID
,      DELIVERY_STATUS
,      PARENT_DUNNING_ID
,      DUNNING_MODE
,      CONFIRMATION_MODE
,      ORG_ID
,      AG_DN_XREF_ID
,      CORRESPONDENCE_DATE
,      ADDT_XML_TEMPLATE_ID
,      ADDT_DELIVERY_STATUS
,      AS_OF_DATE
FROM IEX.IEX_DUNNINGS;

Dependencies

[top of page]

IEX.IEX_DUNNINGS does not reference any database object

IEX.IEX_DUNNINGS is referenced by following:

IEX: IEX_DUNNINGS#