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.

VIEW: APPS.IEX_DELINQUENCIES_STAGE_V

Source

View Text - Preformatted


SELECT DL.PARTY_CUST_ID PARTY_CUST_ID , DL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID , DL.DELINQUENCY_ID DELINQUENCY_ID , DL.TRANSACTION_ID TRANSACTION_ID , DL.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID , DL.STATUS OPEN_CLOSE_STATUS , IEX_UTILITIES.get_lookup_meaning('IEX_DELINQUENCY_STATUS','DELINQUENT') STATUS , 0 BANKRUPTCY_ID , 0 WRITEOFF_ID , 0 REPOSSESSION_ID , 0 LITIGATION_ID , DL.CASE_ID CASE_ID , DL.SCORE_VALUE SCORE_VALUE , DL.UWQ_STATUS UWQ_STATUS , DL.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID , DL.CREATION_DATE CREATION_DATE , DL.LAST_UPDATE_DATE LAST_UPDATE_DATE , DL.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID , DL.ORG_ID ORG_ID FROM IEX_DELINQUENCIES DL WHERE 1=1 UNION ALL SELECT DL.PARTY_CUST_ID PARTY_CUST_ID , DL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID , DL.DELINQUENCY_ID DELINQUENCY_ID , DL.TRANSACTION_ID TRANSACTION_ID , DL.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID , DL.STATUS OPEN_CLOSE_STATUS , IEX_UTILITIES.get_lookup_meaning('IEX_DELINQUENCY_STATUS','BANKRUPTCY') STATUS, BRP.BANKRUPTCY_ID BANKRUPTCY_ID , 0 WRITEOFF_ID , 0 REPOSSESSION_ID , 0 LITIGATION_ID , DL.CASE_ID CASE_ID , DL.SCORE_VALUE SCORE_VALUE , DL.UWQ_STATUS UWQ_STATUS , DL.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID , BRP.CREATION_DATE CREATION_DATE , BRP.LAST_UPDATE_DATE LAST_UPDATE_DATE , DL.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID , DL.ORG_ID ORG_ID FROM IEX_DELINQUENCIES DL , IEX_BANKRUPTCIES BRP WHERE DL.DELINQUENCY_ID = BRP.DELINQUENCY_ID UNION ALL SELECT DL.PARTY_CUST_ID PARTY_CUST_ID , DL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID , DL.DELINQUENCY_ID DELINQUENCY_ID , DL.TRANSACTION_ID TRANSACTION_ID , DL.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID , DL.STATUS OPEN_CLOSE_STATUS , IEX_UTILITIES.get_lookup_meaning('IEX_DELINQUENCY_STATUS','WRITEOFF') STATUS, 0 BANKRUPTCY_ID , WRF.WRITEOFF_ID WRITEOFF_ID , 0 REPOSSESSION_ID , 0 LITIGATION_ID , DL.CASE_ID CASE_ID , DL.SCORE_VALUE SCORE_VALUE , DL.UWQ_STATUS UWQ_STATUS , DL.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID , WRF.CREATION_DATE CREATION_DATE , WRF.LAST_UPDATE_DATE LAST_UPDATE_DATE , DL.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID , DL.ORG_ID ORG_ID FROM IEX_DELINQUENCIES DL , IEX_WRITEOFFS WRF WHERE DL.DELINQUENCY_ID(+) = WRF.DELINQUENCY_ID UNION ALL SELECT DL.PARTY_CUST_ID PARTY_CUST_ID , DL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID , DL.DELINQUENCY_ID DELINQUENCY_ID , DL.TRANSACTION_ID TRANSACTION_ID , DL.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID , DL.STATUS OPEN_CLOSE_STATUS , IEX_UTILITIES.get_lookup_meaning('IEX_DELINQUENCY_STATUS','REPOSSESSION') STATUS, 0 BANKRUPTCY_ID , 0 WRITEOFF_ID , RPS.REPOSSESSION_ID REPOSSESSION_ID , 0 LITIGATION_ID , DL.CASE_ID CASE_ID , DL.SCORE_VALUE SCORE_VALUE , DL.UWQ_STATUS UWQ_STATUS , DL.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID , RPS.CREATION_DATE CREATION_DATE , RPS.LAST_UPDATE_DATE LAST_UPDATE_DATE , DL.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID , DL.ORG_ID ORG_ID FROM IEX_DELINQUENCIES DL , IEX_REPOSSESSIONS RPS WHERE DL.DELINQUENCY_ID(+) = RPS.DELINQUENCY_ID UNION ALL SELECT DL.PARTY_CUST_ID PARTY_CUST_ID , DL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID , DL.DELINQUENCY_ID DELINQUENCY_ID , DL.TRANSACTION_ID TRANSACTION_ID , DL.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID , DL.STATUS OPEN_CLOSE_STATUS , IEX_UTILITIES.get_lookup_meaning('IEX_DELINQUENCY_STATUS','LITIGATION') STATUS, 0 BANKRUPTCY_ID , 0 WRITEOFF_ID , 0 REPOSSESSION_ID , LTG.LITIGATION_ID LITIGATION_ID , DL.CASE_ID CASE_ID , DL.SCORE_VALUE SCORE_VALUE , DL.UWQ_STATUS UWQ_STATUS , DL.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID , LTG.CREATION_DATE CREATION_DATE ,LTG.LAST_UPDATE_DATE LAST_UPDATE_DATE , DL.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID , DL.ORG_ID ORG_ID FROM IEX_DELINQUENCIES DL , IEX_LITIGATIONS LTG WHERE DL.DELINQUENCY_ID(+) = LTG.DELINQUENCY_ID

View Text - HTML Formatted

SELECT DL.PARTY_CUST_ID PARTY_CUST_ID
, DL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, DL.DELINQUENCY_ID DELINQUENCY_ID
, DL.TRANSACTION_ID TRANSACTION_ID
, DL.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, DL.STATUS OPEN_CLOSE_STATUS
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_DELINQUENCY_STATUS'
, 'DELINQUENT') STATUS
, 0 BANKRUPTCY_ID
, 0 WRITEOFF_ID
, 0 REPOSSESSION_ID
, 0 LITIGATION_ID
, DL.CASE_ID CASE_ID
, DL.SCORE_VALUE SCORE_VALUE
, DL.UWQ_STATUS UWQ_STATUS
, DL.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, DL.CREATION_DATE CREATION_DATE
, DL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DL.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID
, DL.ORG_ID ORG_ID
FROM IEX_DELINQUENCIES DL
WHERE 1=1 UNION ALL SELECT DL.PARTY_CUST_ID PARTY_CUST_ID
, DL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, DL.DELINQUENCY_ID DELINQUENCY_ID
, DL.TRANSACTION_ID TRANSACTION_ID
, DL.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, DL.STATUS OPEN_CLOSE_STATUS
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_DELINQUENCY_STATUS'
, 'BANKRUPTCY') STATUS
, BRP.BANKRUPTCY_ID BANKRUPTCY_ID
, 0 WRITEOFF_ID
, 0 REPOSSESSION_ID
, 0 LITIGATION_ID
, DL.CASE_ID CASE_ID
, DL.SCORE_VALUE SCORE_VALUE
, DL.UWQ_STATUS UWQ_STATUS
, DL.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, BRP.CREATION_DATE CREATION_DATE
, BRP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DL.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID
, DL.ORG_ID ORG_ID
FROM IEX_DELINQUENCIES DL
, IEX_BANKRUPTCIES BRP
WHERE DL.DELINQUENCY_ID = BRP.DELINQUENCY_ID UNION ALL SELECT DL.PARTY_CUST_ID PARTY_CUST_ID
, DL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, DL.DELINQUENCY_ID DELINQUENCY_ID
, DL.TRANSACTION_ID TRANSACTION_ID
, DL.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, DL.STATUS OPEN_CLOSE_STATUS
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_DELINQUENCY_STATUS'
, 'WRITEOFF') STATUS
, 0 BANKRUPTCY_ID
, WRF.WRITEOFF_ID WRITEOFF_ID
, 0 REPOSSESSION_ID
, 0 LITIGATION_ID
, DL.CASE_ID CASE_ID
, DL.SCORE_VALUE SCORE_VALUE
, DL.UWQ_STATUS UWQ_STATUS
, DL.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, WRF.CREATION_DATE CREATION_DATE
, WRF.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DL.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID
, DL.ORG_ID ORG_ID
FROM IEX_DELINQUENCIES DL
, IEX_WRITEOFFS WRF
WHERE DL.DELINQUENCY_ID(+) = WRF.DELINQUENCY_ID UNION ALL SELECT DL.PARTY_CUST_ID PARTY_CUST_ID
, DL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, DL.DELINQUENCY_ID DELINQUENCY_ID
, DL.TRANSACTION_ID TRANSACTION_ID
, DL.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, DL.STATUS OPEN_CLOSE_STATUS
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_DELINQUENCY_STATUS'
, 'REPOSSESSION') STATUS
, 0 BANKRUPTCY_ID
, 0 WRITEOFF_ID
, RPS.REPOSSESSION_ID REPOSSESSION_ID
, 0 LITIGATION_ID
, DL.CASE_ID CASE_ID
, DL.SCORE_VALUE SCORE_VALUE
, DL.UWQ_STATUS UWQ_STATUS
, DL.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, RPS.CREATION_DATE CREATION_DATE
, RPS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DL.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID
, DL.ORG_ID ORG_ID
FROM IEX_DELINQUENCIES DL
, IEX_REPOSSESSIONS RPS
WHERE DL.DELINQUENCY_ID(+) = RPS.DELINQUENCY_ID UNION ALL SELECT DL.PARTY_CUST_ID PARTY_CUST_ID
, DL.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, DL.DELINQUENCY_ID DELINQUENCY_ID
, DL.TRANSACTION_ID TRANSACTION_ID
, DL.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, DL.STATUS OPEN_CLOSE_STATUS
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_DELINQUENCY_STATUS'
, 'LITIGATION') STATUS
, 0 BANKRUPTCY_ID
, 0 WRITEOFF_ID
, 0 REPOSSESSION_ID
, LTG.LITIGATION_ID LITIGATION_ID
, DL.CASE_ID CASE_ID
, DL.SCORE_VALUE SCORE_VALUE
, DL.UWQ_STATUS UWQ_STATUS
, DL.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, LTG.CREATION_DATE CREATION_DATE
, LTG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DL.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID
, DL.ORG_ID ORG_ID
FROM IEX_DELINQUENCIES DL
, IEX_LITIGATIONS LTG
WHERE DL.DELINQUENCY_ID(+) = LTG.DELINQUENCY_ID