IGI Installment Terms: Installment Audit Report- Not Supported: Reserved For Future Use
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
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 |