AP Accounts Payable Trial Balance

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Payables
Source: Accounts Payable Trial Balance
Short Name: APTBRPT
DB package: XLA_TB_AP_REPORT_PVT
               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
Parameter NameSQL textValidation
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
Download
Related Blitz Reports
AR Customers and Sites CAC Resource Costs PA Budget Upload CAC Resources by Department Setup CAC Inventory Pending Cost Adjustment - No Currencies PA Project Budget PA Missing Timecards PA Revenue, Cost, Budgets by Resources CAC WIP Account Value CAC AP Accrual IR ISO Match Analysis
Blitz Report™