AP 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 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 XLA Open Account AP Balances Listing CE Israel - Bank Statement Reconciliation XLA Open Account Balances Listing CAC WIP Pending Cost Adjustment XDO Publisher Data Definitions AP Payables Posted Invoice Register AP Payables Posted Payment Register
Blitz Report™

Blitz Report™ provides multiple benefits: