APPS.ASP_INVOICE_CONTENT_PROVIDER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 75

    SELECT
      PARTY.PARTY_ID as customer_id,
      PARTY.PARTY_NAME as customer_name,
      CT.TRX_NUMBER as transaction_number,
      PS.DUE_DATE
    FROM
       AR_PAYMENT_SCHEDULES_ALL PS
      ,HZ_CUST_ACCOUNTS_ALL CUST_ACCT
      ,HZ_PARTIES PARTY
      ,IEX_DEL_ALERTS_PUB_V DEL -- IEX_DELINQUENCIES.STATUS in ('DELINQUENT', 'PREDELINQUENT')
      ,RA_CUSTOMER_TRX_ALL CT
    WHERE
        PS.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
    AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
    AND PS.CUSTOMER_TRX_ID = DEL.TRANSACTION_ID
    AND PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
    AND PS.PAYMENT_SCHEDULE_ID = DEL.PAYMENT_SCHEDULE_ID
    AND DEL.DELINQUENCY_ID = c_delinquency_id
    AND rownum < 2;