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
AR Customers and Sites AR Transactions and Lines IGI Standing Charges: Listing- Not Supported: Reserved For Future Use AR Aging and Current Open AR ONT Orders and Lines XX AR Transactions and Lines JG Regional Invoice Format Program- Not Supported: Reserved For Future Use PPF_WP3_OM_DETAILS AR Transactions and Payments
Blitz Report™

Blitz Report™ provides multiple benefits: