IGI Combined Basis Reports: Receivables - draft

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