IGI Installment Terms: Installment Audit Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Installment Terms: Installment Audit Report
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
Run IGI Installment Terms: Installment Audit Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Operating Unit 
 
 LOV
From Date 
 
 Date
To Date 
 
 Date
Customer Name 
 
 LOV Oracle
Download
Related Blitz Reports
IGI Standing Charges: Listing- Not Supported: Reserved For Future Use AR Customers and Sites XX AR Transactions and Lines AR Transactions and Lines JG Regional Invoice Format Program- Not Supported: Reserved For Future Use PPF_WP3_OM_DETAILS AR Transactions and Payments AR Open Items Revaluation AR Miscellaneous Receipts
Blitz Report™

Blitz Report™ provides multiple benefits: