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