1. Tables and Views for Financials
  2. IEX_F_SCORE_INVOICES_V

IEX_F_SCORE_INVOICES_V

Details

  • Schema: FUSION

  • Object owner: IEX

  • Object type: VIEW

Columns

Name

PAYMENT_SCHEDULE_ID

Query

SQL_Statement

SELECT /*+ full(ar) parallel(ar) */ 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 dll

where dll.payment_schedule_id = ar.payment_schedule_id

and dll.status IN ('DELINQUENT', 'PREDELINQUENT'))

)