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]

VIEW: APPS.IEX_DEL_ALERTS_PUB_V

Object Details

Object Name:	IEX_DEL_ALERTS_PUB_V
Object Type:	VIEW
Owner:	APPS
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.

View Type

Internal

[View Source]

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
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
CASE_ID	NUMBER			Case which this delinquency is part off
DUNN_YN	VARCHAR2	(10)		Should we send dunning?
STATUS	VARCHAR2	(30)		What is the delinquency status
ORG_ID	NUMBER			Organization identifier
UNPAID_REASON_CODE	VARCHAR2	(240)		Lookup code for unpaid reason. User selectable.
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_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

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
,      CUST_ACCOUNT_ID
,      TRANSACTION_ID
,      PAYMENT_SCHEDULE_ID
,      CASE_ID
,      DUNN_YN
,      STATUS
,      ORG_ID
,      UNPAID_REASON_CODE
,      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_ACTIVE_DATE
,      UWQ_COMPLETE_DATE
,      CUSTOMER_SITE_USE_ID
FROM APPS.IEX_DEL_ALERTS_PUB_V;

Dependencies

[top of page]

APPS.IEX_DEL_ALERTS_PUB_V references the following:

APPS: IEX_DELINQUENCIES_ALL

APPS.IEX_DEL_ALERTS_PUB_V is referenced by following:

APPS: ASP_ALERTS_INVOICE - show dependent code; ASP_INVOICE_ALERT_AGENT - show dependent code; ASP_INVOICE_CONTENT_PROVIDER - show dependent code