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_DELINQUENCIES_ALL

Object Details

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

Holds transaction data about customer delinquencies.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEX_DELINQUENCIES_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DELINQUENCY_ID
IEX_DELINQUENCIES_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID
IEX_DELINQUENCIES_ALL_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	CASE_ID
IEX_DELINQUENCIES_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ACCOUNT_ID STATUS
IEX_DELINQUENCIES_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_CUST_ID STATUS
IEX_DELINQUENCIES_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_SITE_USE_ID STATUS
IEX_DELINQUENCIES_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS
IEX_DELINQUENCIES_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ACCOUNT_ID TRANSACTION_ID
IEX_DELINQUENCIES_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_CUST_ID CREATION_DATE
IEX_DELINQUENCIES_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
IEX_DELINQUENCIES_ALL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DELINQUENCY_ID	NUMBER		Yes	Primary key
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
SECURITY_GROUP_ID	NUMBER			Subscriber id, for CRM Online Services use
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
OBJECT_VERSION_NUMBER	NUMBER		Yes	Standard HTML front end column
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_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PARTY_CUST_ID	NUMBER			Customer ID of the debtor. FKey to HZ_PARTIES
PARTY_CLIENT_ID	NUMBER			PArty ID of the customer that owns the debt. FKey to HZ_PARTIES
CUST_ACCOUNT_ID	NUMBER			Account ID of the debtor. FKey to hz_party_accounts
TRANSACTION_ID	NUMBER			FKey to AR_CUSTOMER_TRX_ALL
PAYMENT_SCHEDULE_ID	NUMBER			FKey to ar_payment_schedules_all
AGING_BUCKET_LINE_ID	NUMBER			FKey to ar_aging_bucket_lines
CASE_ID	NUMBER			Case which this delinquency is part off
RESOURCE_ID	NUMBER			Agent that works on this delinquency
DUNN_YN	VARCHAR2	(10)		Should we send dunning?
AUTOASSIGN_YN	VARCHAR2	(10)		Should we autoassign this delinquency?
STATUS	VARCHAR2	(30)		What is the delinquency status
CAMPAIGN_SCHED_ID	NUMBER			What marketing campaign are we working with
ORG_ID	NUMBER			Organization identifier
UNPAID_REASON_CODE	VARCHAR2	(240)		Lookup code for unpaid reason. User selectable.
STRATEGY_ID	NUMBER
CREDIT_HOLD_REQUEST_FLAG	VARCHAR2	(1)		Have we requested credit hold for this delinquency?
CREDIT_HOLD_APPROVED_FLAG	VARCHAR2	(1)		Was the credit hold approved?
SERVICE_HOLD_REQUEST_FLAG	VARCHAR2	(1)		Have we requested service hold for this delinquency?
SERVICE_HOLD_APPROVED_FLAG	VARCHAR2	(1)		Was the service hold approved?
SCORE_VALUE	NUMBER			Last score value for this delinquency.
SCORE_ID	NUMBER			Score engine ID used to generate the value in SCORE_VALUE
SOURCE_PROGRAM_NAME	VARCHAR2	(100)		SOURCE_PROGRAM_NAME
PREDICTED_RECOVERY_AMOUNT	NUMBER			Predicted Recovery amount ( OKL specific) . This is the expected amount to be recovered for the case.
PREDICTED_CHANCE	NUMBER			Predicted Chance ( OKL specific) . This is expected recovery % for the debt
UWQ_STATUS	VARCHAR2	(30)		Status of this delinquency on UWQ. Active/Pending/Complete
UWQ_ACTIVE_DATE	DATE			Date this delinquency will change into the Active bucket on UWQ.
UWQ_COMPLETE_DATE	DATE			Date this delinquency moved into the COMPLETE bucket on UWQ.
CUSTOMER_SITE_USE_ID	NUMBER			FK to HZ_CUST_SITE_USES_ALL
STAGED_DUNNING_LEVEL	NUMBER			Dunning level of the item as printed on the dunning correspondence
DUNNING_LEVEL_OVERRIDE_DATE	DATE			Dunning level override date from Transaction Tab in Collections

Query Text

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


SELECT DELINQUENCY_ID
,      LAST_UPDATE_DATE
,      SECURITY_GROUP_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_ID
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PARTY_CUST_ID
,      PARTY_CLIENT_ID
,      CUST_ACCOUNT_ID
,      TRANSACTION_ID
,      PAYMENT_SCHEDULE_ID
,      AGING_BUCKET_LINE_ID
,      CASE_ID
,      RESOURCE_ID
,      DUNN_YN
,      AUTOASSIGN_YN
,      STATUS
,      CAMPAIGN_SCHED_ID
,      ORG_ID
,      UNPAID_REASON_CODE
,      STRATEGY_ID
,      CREDIT_HOLD_REQUEST_FLAG
,      CREDIT_HOLD_APPROVED_FLAG
,      SERVICE_HOLD_REQUEST_FLAG
,      SERVICE_HOLD_APPROVED_FLAG
,      SCORE_VALUE
,      SCORE_ID
,      SOURCE_PROGRAM_NAME
,      PREDICTED_RECOVERY_AMOUNT
,      PREDICTED_CHANCE
,      UWQ_STATUS
,      UWQ_ACTIVE_DATE
,      UWQ_COMPLETE_DATE
,      CUSTOMER_SITE_USE_ID
,      STAGED_DUNNING_LEVEL
,      DUNNING_LEVEL_OVERRIDE_DATE
FROM IEX.IEX_DELINQUENCIES_ALL;

Dependencies

[top of page]

IEX.IEX_DELINQUENCIES_ALL does not reference any database object

IEX.IEX_DELINQUENCIES_ALL is referenced by following:

IEX: IEX_DELINQUENCIES_ALL#