IGI Combined Basis Reports: Receivables - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Public Sector Financials International
Source: Combined Basis Reports: Receivables Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIRCCBR_XML
DB package: IGI_IGIRCCBR_XMLP_PKG
Run IGI Combined Basis Reports: Receivables - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
select &p_seg_name account,
           doc_seq_num  doc_seq,
           trans_number  inv_id,
           customer_number  cust_id,
           customer_name  cust_name,
           accounting_date  gl_date,
           amount,
          currency_code, 
	IGI_IGIRCCBR_XMLP_PKG.cf_cust_nameformula(customer_number, customer_name) CF_CUST_NAME
from igi_cbr_arc_interface
where request_id = :p_request_id
and  &p_seg_name between nvl(:p_account_segment_from, &p_seg_name) and nvl(:p_account_segment_to, &p_seg_name)
ORDER BY 8 ASC,1 ASC
Download
Related Blitz Reports
IGI Combined Basis Reports: Payables Report- Not Supported: Reserved For Future Use IGI Combined Basis Reports: Detail Report- Not Supported: Reserved For Future Use HACTL AR Standard Receipts IGI Standing Charges: Transaction History Report- Not Supported: Reserved For Future Use IGI Standing Charges: Transaction Report- Not Supported: Reserved For Future Use BEN COBRA Benefit Notification Letter PAY NZ Generate EI Amended PAY NZ Generate EI Payday PAY NZ Payday Reconciliation
Blitz Report™

Blitz Report™ provides multiple benefits: