AP Accounts Payable Negative Supplier Balance

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Application: Payables
Source: Accounts Payable Negative Supplier Balance
Short Name: APXNVBAL
DB package: XLA_TB_AP_REPORT_PVT
Run AP Accounts Payable Negative Supplier Balance and other Oracle EBS reports with Blitz Report™ on our demo environment
select 
 x.account liability_account
,x.third_party_name supplier_name
&sum_or_detail_cols
from
 (select
    xtb.account
  ,xtb.third_party_name
  ,xtb.user_trx_identifier_value_3
  ,xtb.user_trx_identifier_value_10
  ,xtb.user_trx_identifier_value_8
  ,xtb.ledger_currency_code
  ,xtb.src_acctd_rounded_orig_amt
  ,xtb.src_acctd_rounded_rem_amt
  ,sum(xtb.src_acctd_rounded_rem_amt) over(partition by xtb.account,xtb.third_party_name)  sum_supp_liability
  from 
    (&p_template_sql_statement
     &p_sql_statement
    ) xtb
 ) x
where
      1=1
and x.sum_supp_liability < 0
&summary_group_by
Parameter Name SQL text Validation
Operating Unit 
 
 LOV Oracle
Report Definition 
 
 LOV Oracle
As of Date 
 
 Date
Third Party Name 
 
 LOV Oracle
Show Transaction Detail 
 
 LOV Oracle
Download
Related Blitz Reports
AP Trial Balance CE General Ledger Reconciliation CE Israel - Bank Statement Reconciliation XLA Open Account AP Balances Listing XLA Open Account Balances Listing XDO Publisher Data Definitions RWB Reports DBA External Table Creation RWB Execution History
Blitz Report™

Blitz Report™ provides multiple benefits: