VIEW: APPS.IEX_DELINQUENCIES_NEW_V

Source

View Text - Preformatted

SELECT PS.PAYMENT_SCHEDULE_ID ,PS.CUSTOMER_TRX_ID ,CST.PARTY_ID ,CST.CUST_ACCOUNT_ID ,PS.CLASS ,PS.STATUS ,PS.AMOUNT_DUE_ORIGINAL ,PS.AMOUNT_DUE_REMAINING ,PS.TRX_DATE ,PS.GL_DATE ,DECODE(PS.CUSTOMER_ID , -1,'' ,-2,'', -3,'', PS.DUE_DATE) FROM HZ_CUST_ACCOUNTS CST ,AR_PAYMENT_SCHEDULES PS WHERE CST.CUST_ACCOUNT_ID(+) = PS.CUSTOMER_ID AND PS.CLASS IN ('DM','INV', 'CB') AND PS.AMOUNT_DUE_REMAINING > 0 AND PS.STATUS = 'OP' AND (ABS(PS.AMOUNT_IN_DISPUTE) < PS.AMOUNT_DUE_REMAINING OR PS.AMOUNT_IN_DISPUTE IS NULL) AND PS.DUE_DATE < trunc(SYSDATE) AND PS.SELECTED_FOR_RECEIPT_BATCH_ID IS NULL

View Text - HTML Formatted

SELECT PS.PAYMENT_SCHEDULE_ID
, PS.CUSTOMER_TRX_ID
, CST.PARTY_ID
, CST.CUST_ACCOUNT_ID
, PS.CLASS
, PS.STATUS
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING
, PS.TRX_DATE
, PS.GL_DATE
, DECODE(PS.CUSTOMER_ID
, -1
, ''
, -2
, ''
, -3
, ''
, PS.DUE_DATE)
FROM HZ_CUST_ACCOUNTS CST
, AR_PAYMENT_SCHEDULES PS
WHERE CST.CUST_ACCOUNT_ID(+) = PS.CUSTOMER_ID
AND PS.CLASS IN ('DM'
, 'INV'
, 'CB')
AND PS.AMOUNT_DUE_REMAINING > 0
AND PS.STATUS = 'OP'
AND (ABS(PS.AMOUNT_IN_DISPUTE) < PS.AMOUNT_DUE_REMAINING OR PS.AMOUNT_IN_DISPUTE IS NULL)
AND PS.DUE_DATE < TRUNC(SYSDATE)
AND PS.SELECTED_FOR_RECEIPT_BATCH_ID IS NULL