AP Accounts Payable Negative Supplier Balance

Description
Categories: BI Publisher, 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