VIEW: APPS.IEX_DEL_CONTRACTS_NEW_V

Source

View Text - Preformatted

SELECT rct.INTERFACE_HEADER_ATTRIBUTE12 CONTRACT_ID, rct.INTERFACE_HEADER_ATTRIBUTE6 CONTRACT_NUMBER, PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, PS.CUSTOMER_TRX_ID CUSTOMER_TRX_ID, CST.PARTY_ID PARTY_ID, CST.CUST_ACCOUNT_ID CUST_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 GL_DATE, PS.DUE_DATE DUE_DATE FROM HZ_CUST_ACCOUNTS CST , ra_customer_trx_all rct, AR_PAYMENT_SCHEDULES_ALL PS WHERE CST.cust_account_id = rct.bill_to_customer_id AND ps.customer_trx_id = rct.customer_trx_id AND rct.INTERFACE_HEADER_CONTEXT = 'OKL_CONTRACTS' 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 RCT.INTERFACE_HEADER_ATTRIBUTE12 CONTRACT_ID
, RCT.INTERFACE_HEADER_ATTRIBUTE6 CONTRACT_NUMBER
, PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PS.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CST.PARTY_ID PARTY_ID
, CST.CUST_ACCOUNT_ID CUST_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 GL_DATE
, PS.DUE_DATE DUE_DATE
FROM HZ_CUST_ACCOUNTS CST
, RA_CUSTOMER_TRX_ALL RCT
, AR_PAYMENT_SCHEDULES_ALL PS
WHERE CST.CUST_ACCOUNT_ID = RCT.BILL_TO_CUSTOMER_ID
AND PS.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND RCT.INTERFACE_HEADER_CONTEXT = 'OKL_CONTRACTS'
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