AP Accounts Payable Trial Balance
Description
- Categories
- BI Publisher
- Application
- Payables
- Source
- Accounts Payable Trial Balance
- Short Name
- APTBRPT
- DB package
- XLA_TB_AP_REPORT_PVT
Imported from BI Publisher
SQL 15 lines
SELECT (select name from hr_operating_units where organization_id =:P_SECURITY_ID_INT_1) OU_NAME ,:P_REPORT_DEFINITION_DSP REPORT_DEFINITION ,:P_JOURNAL_SOURCE_DSP JOURNAL_SOURCE ,to_char(:P_START_DATE ,'YYYY-MM-DD') START_DATE ,to_char(:P_AS_OF_DATE ,'YYYY-MM-DD') AS_OF_DATE ,:P_THIRD_PARTY_NAME THIRD_PARTY_NAME ,:P_SHOW_TRX_DETAIL_DSP SHOW_APPLIED_TRX_DETAIL ,:P_INCL_WRITE_OFF_DSP INCLUDE_WRITE_OFF ,:P_ACCOUNT_FROM ACCOUNT_FROM ,:P_ACCOUNT_TO ACCOUNT_TO ,:P_ACCT_BALANCE_DSP ACCOUNT_BALANCE ,:P_REPORT_MODE_DSP REPORT_MODE FROM dual |
Parameters 11
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV Oracle | |
| Report Definition | LOV Oracle | |
| Journal Source | LOV Oracle | |
| As of Date | Date | |
| Third Party Name | LOV Oracle | |
| Show Transaction Detail | LOV Oracle | |
| Include Write Offs | LOV Oracle | |
| Account From | Char | |
| Account To | Char | |
| Include SLA Manuals/Other Sources | LOV Oracle | |
| Report Mode | LOV Oracle |