IGI Installment Terms: Installment Audit Report- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- 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
Imported from BI Publisher
Installment Terms: Installment Audit Report
Installment Terms: Installment Audit Report
SQL 35 lines
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 |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV | |
| From Date | Date | |
| To Date | Date | |
| Customer Name | LOV Oracle |