IGI Installment Terms: Installment Audit - draft

Description
Categories: BI Publisher, Financials
Application: Public Sector Financials International
Source: Installment Terms: Installment Audit Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIRTAUD_XML
DB package: IGI_IGIRTAUD_XMLP_PKG
SELECT   gsob.NAME book_name
            , party.PARTY_NAME 
            , cust.ACCOUNT_NUMBER
            , trx.TRX_NUMBER invoice_num
            , aud.CREATION_DATE date_changed
            , fnd.USER_NAME approver
            , fnd2.USER_NAME use_r
            , ter.NAME  ter_ms
            , aud.START_DATE
FROM     RA_TERMS ter
            ,  FND_USER fnd  
            ,  FND_USER fnd2
            ,  IGI_INSTALMENT_AUDIT_V aud
            , RA_CUSTOMER_TRX trx
            , HZ_PARTIES party
            , HZ_CUST_ACCOUNTS cust
            , GL_SETS_OF_BOOKS gsob
WHERE   gsob.SET_OF_BOOKS_ID = :P_SOB_ID
AND      trx.SET_OF_BOOKS_ID = gsob.SET_OF_BOOKS_ID
AND      cust.CUST_ACCOUNT_ID = trx.BILL_TO_CUSTOMER_ID
AND      party.party_id = cust.party_id
AND      trx.BILL_TO_CUSTOMER_ID LIKE nvl(:P_CUST_ID, '%')
AND      aud.RA_CUSTOMER_TRX_ID = trx.CUSTOMER_TRX_ID
AND      to_date(to_char(aud.CREATION_DATE), 'DD-MON-RR')
             BETWEEN to_date(to_char(:CP_DATE_LOW), 'DD-MON-RR')
             AND to_date(to_char(:CP_DATE_HIGH), 'DD-MON-RR')
AND      aud.RA_TERM_ID = ter.TERM_ID
AND      fnd.USER_ID = aud.FND_USER_ID
AND      fnd2.USER_ID = aud.CREATED_BY
ORDER BY 
        party.PARTY_NAME
      , invoice_num
       , to_number(to_char(date_changed,'J'))
      , ter_ms
Parameter Name SQL text Validation
SOB Id
 
Number
Customer Name
 
LOV Oracle
To Date
 
Date
From Date
 
Date
Ask a question