VIEW: APPS.IEX_DELINQUENCIES_V

Source

View Text - Preformatted

SELECT PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID , PS.CUSTOMER_TRX_ID TRANSACTION_ID , CST.PARTY_ID PARTY_CUST_ID , CST.CUST_ACCOUNT_ID CUSTOMER_ACCOUNT_ID , PS.CLASS CLASS , PS.STATUS STATUS , PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL , PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING , PS.TRX_DATE TRX_DATE , PS.GL_DATE TRX_GL_DATE , DECODE(PS.CUSTOMER_ID , -1,'' , -2,'', -3,'', PS.DUE_DATE) TRX_DUE_DATE FROM HZ_CUST_ACCOUNTS CST , AR_PAYMENT_SCHEDULES PS WHERE PS.CLASS IN ('DM','INV') AND PS.AMOUNT_DUE_REMAINING > 0 AND PS.STATUS = 'OP' AND PS.DISPUTE_DATE IS NULL AND PS.DUE_DATE < SYSDATE AND PS.SELECTED_FOR_RECEIPT_BATCH_ID IS NULL AND CST.CUST_ACCOUNT_ID(+) = PS.CUSTOMER_ID

View Text - HTML Formatted

SELECT PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PS.CUSTOMER_TRX_ID TRANSACTION_ID
, CST.PARTY_ID PARTY_CUST_ID
, CST.CUST_ACCOUNT_ID CUSTOMER_ACCOUNT_ID
, PS.CLASS CLASS
, PS.STATUS STATUS
, PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, PS.TRX_DATE TRX_DATE
, PS.GL_DATE TRX_GL_DATE
, DECODE(PS.CUSTOMER_ID
, -1
, ''
, -2
, ''
, -3
, ''
, PS.DUE_DATE) TRX_DUE_DATE
FROM HZ_CUST_ACCOUNTS CST
, AR_PAYMENT_SCHEDULES PS
WHERE PS.CLASS IN ('DM'
, 'INV')
AND PS.AMOUNT_DUE_REMAINING > 0
AND PS.STATUS = 'OP'
AND PS.DISPUTE_DATE IS NULL
AND PS.DUE_DATE < SYSDATE
AND PS.SELECTED_FOR_RECEIPT_BATCH_ID IS NULL
AND CST.CUST_ACCOUNT_ID(+) = PS.CUSTOMER_ID