IGI Combined Basis Reports: Payables Report- Not Supported: Reserved For Future Use

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Combined Basis Reports: Payables Report
Application: Public Sector Financials International
Source: Combined Basis Reports: Payables Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIPCBAP_XML
DB package: IGI_IGIPCBAP_XMLP_PKG
Run IGI Combined Basis Reports: Payables Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT	  ORG_ID
	, ORGANIZATION	
	, ACCOUNT_NUM
	, DOC_SEQ_NUM
	, INVOICE_NUM
	, INVOICE_DATE
	, VENDOR_NUM
	, ROUND(AMOUNT,2) AMOUNT
	, ROUND(OPENING_VAR,2) OPENING_VAR,
	IGI_IGIPCBAP_XMLP_PKG.CF_NO_DATAFORMULA(INVOICE_NUM) CF_NO_DATA
FROM	IGI_CBR_AP_INTERFACE
ORDER BY 1 ASC,2 ASC,3 ASC
Parameter Name SQL text Validation
Primary Ledger
 
LOV Oracle
Secondary Ledger
 
LOV Oracle
From Account
 
Char
To Account
 
Char
From Period
 
LOV Oracle
To Period
 
LOV Oracle
Blitz Report™