VIEW: APPS.IEX_F_SCORE_INVOICES_BR_V

Source

View Text - Preformatted

SELECT ar.payment_schedule_id FROM ar_payment_schedules ar WHERE ( ar.CLASS IN ('INV', 'DM', 'CB', 'BR') and ar.status = 'OP' ) or ( ar.CLASS IN ('INV', 'DM', 'CB', 'BR') and ar.status = 'CL' and exists (select 1 from iex_delinquencies_all dll where dll.payment_schedule_id = ar.payment_schedule_id and dll.status in ( 'DELINQUENT', 'PREDELINQUENT') ) )

View Text - HTML Formatted

SELECT AR.PAYMENT_SCHEDULE_ID
FROM AR_PAYMENT_SCHEDULES AR
WHERE ( AR.CLASS IN ('INV'
, 'DM'
, 'CB'
, 'BR')
AND AR.STATUS = 'OP' ) OR ( AR.CLASS IN ('INV'
, 'DM'
, 'CB'
, 'BR')
AND AR.STATUS = 'CL'
AND EXISTS (SELECT 1
FROM IEX_DELINQUENCIES_ALL DLL
WHERE DLL.PAYMENT_SCHEDULE_ID = AR.PAYMENT_SCHEDULE_ID
AND DLL.STATUS IN ( 'DELINQUENT'
, 'PREDELINQUENT') ) )