AP Negative Supplier Balance
Description
- Categories
- Enginatics, R12 only
- Application
- Payables
- Source
- Accounts Payable Negative Supplier Balance
- Short Name
- APXNVBAL
- DB package
- XLA_TB_AP_REPORT_PVT
- Repository
- GitHub
SQL 24 lines
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 |
Parameters 5
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV Oracle | |
| Report Definition | LOV Oracle | |
| As of Date | Date | |
| Third Party Name | LOV Oracle | |
| Show Transaction Detail | LOV Oracle |