VIEW: APPS.IEX_DEL_ALERTS_PUB_V

Source

View Text - Preformatted

SELECT ID.DELINQUENCY_ID,ID.LAST_UPDATE_DATE,ID.SECURITY_GROUP_ID,ID.LAST_UPDATED_BY,ID.LAST_UPDATE_LOGIN,ID.CREATION_DATE,ID.CREATED_BY,ID.PROGRAM_ID,ID.OBJECT_VERSION_NUMBER,ID.REQUEST_ID,ID.PROGRAM_APPLICATION_ID,ID.PROGRAM_UPDATE_DATE,ID.PARTY_CUST_ID,ID.CUST_ACCOUNT_ID,ID.TRANSACTION_ID,ID.PAYMENT_SCHEDULE_ID,ID.CASE_ID,ID.DUNN_YN,ID.STATUS,ID.ORG_ID,ID.UNPAID_REASON_CODE,ID.CREDIT_HOLD_REQUEST_FLAG,ID.CREDIT_HOLD_APPROVED_FLAG,ID.SERVICE_HOLD_REQUEST_FLAG,ID.SERVICE_HOLD_APPROVED_FLAG,ID.SCORE_VALUE,ID.SCORE_ID,ID.SOURCE_PROGRAM_NAME,ID.PREDICTED_RECOVERY_AMOUNT,ID.PREDICTED_CHANCE,ID.UWQ_ACTIVE_DATE,ID.UWQ_COMPLETE_DATE,ID.CUSTOMER_SITE_USE_ID FROM IEX_DELINQUENCIES_ALL ID WHERE ID.STATUS in ('DELINQUENT', 'PREDELINQUENT')

View Text - HTML Formatted

SELECT ID.DELINQUENCY_ID
, ID.LAST_UPDATE_DATE
, ID.SECURITY_GROUP_ID
, ID.LAST_UPDATED_BY
, ID.LAST_UPDATE_LOGIN
, ID.CREATION_DATE
, ID.CREATED_BY
, ID.PROGRAM_ID
, ID.OBJECT_VERSION_NUMBER
, ID.REQUEST_ID
, ID.PROGRAM_APPLICATION_ID
, ID.PROGRAM_UPDATE_DATE
, ID.PARTY_CUST_ID
, ID.CUST_ACCOUNT_ID
, ID.TRANSACTION_ID
, ID.PAYMENT_SCHEDULE_ID
, ID.CASE_ID
, ID.DUNN_YN
, ID.STATUS
, ID.ORG_ID
, ID.UNPAID_REASON_CODE
, ID.CREDIT_HOLD_REQUEST_FLAG
, ID.CREDIT_HOLD_APPROVED_FLAG
, ID.SERVICE_HOLD_REQUEST_FLAG
, ID.SERVICE_HOLD_APPROVED_FLAG
, ID.SCORE_VALUE
, ID.SCORE_ID
, ID.SOURCE_PROGRAM_NAME
, ID.PREDICTED_RECOVERY_AMOUNT
, ID.PREDICTED_CHANCE
, ID.UWQ_ACTIVE_DATE
, ID.UWQ_COMPLETE_DATE
, ID.CUSTOMER_SITE_USE_ID
FROM IEX_DELINQUENCIES_ALL ID
WHERE ID.STATUS IN ('DELINQUENT'
, 'PREDELINQUENT')