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
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_SQL_STATEMENT
     AND :L_RUN_DETAIL_REPORT = 'Y'
    ) 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
Show Transaction Detail
,sum(x.SRC_ACCTD_ROUNDED_ORIG_AMT) "Amount"
,sum(x.SRC_ACCTD_ROUNDED_REM_AMT) "Remaining Amount"
Show Transaction Detail
,x.USER_TRX_IDENTIFIER_VALUE_3 "Invoice Number"
,x.USER_TRX_IDENTIFIER_VALUE_10 "Invoice Description"
,substr(x.USER_TRX_IDENTIFIER_VALUE_8,1,10)   "Invoice Date"
,x.LEDGER_CURRENCY_CODE "Currency"
,x.SRC_ACCTD_ROUNDED_ORIG_AMT "Amount"
,x.SRC_ACCTD_ROUNDED_REM_AMT "Remaining Amount"
Show Transaction Detail
group by
 x.ACCOUNT
,x.THIRD_PARTY_NAME
order by
  1,2
Show Transaction Detail
order by
  1,2,3,5
Account From
 
Account To
 
Account Balance
 
LOV Oracle
XLA_SRS_SUBLEDGERS
 
LOV Oracle
Chart of Accounts
 
Number
Summarize Balances
 
LOV Oracle
Custom Parameter 3
 
Include Write Offs
 
LOV Oracle
Journal Source
 
LOV Oracle
Security
 
Security Identifier (Character)
 
Show Transaction Detail 1
 
LOV Oracle
Start Date
 
Date
Valuation Method