IGI Range Code Listing- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: BUD: Budgeting: Range Code Listing
Application: Public Sector Financials International
Source: Budgeting: Range Code Listing (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBRCL_XML
DB package: IGI_IGIGBRCL_XMLP_PKG
Run IGI Range Code Listing- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT	codes.RANGE_CODE, 
	codes.DESCRIPTION,
	codes.START_DATE_ACTIVE,
	codes.END_DATE_ACTIVE,
	gsob.NAME SOB_NAME,
	&CP_FLEX_LOW LOW_RANGE,
	&CP_FLEX_HIGH HIGH_RANGE
FROM	IGI_BUD_RANGE_CODES codes,
	IGI_BUD_CODE_RANGES ranges,
	GL_SETS_OF_BOOKS gsob
WHERE 	ranges.RANGE_CODE = codes.RANGE_CODE
AND	ranges.SET_OF_BOOKS_ID = codes.SET_OF_BOOKS_ID
AND	ranges.SET_OF_BOOKS_ID = :P_SOB
AND 	nvl(codes.REPORT_RANGE_FLAG,'N') != 'Y'
AND 	gsob.SET_OF_BOOKS_ID = ranges.SET_OF_BOOKS_ID
ORDER BY 1, 6
Parameter Name SQL text Validation
Ledger ID 
 
 LOV Oracle
Download
Related Blitz Reports
IGI Balanced Budget Journal Input Proforma- Not Supported: Reserved For Future Use IGI Reason Code Listing- Not Supported: Reserved For Future Use IGI Profile Code Listing- Not Supported: Reserved For Future Use IGI Balanced Budget History Report- Not Supported: Reserved For Future Use IGI Balanced Budget Journal Report- Not Supported: Reserved For Future Use IGI UnBalanced Budget History Report- Not Supported: Reserved For Future Use IGI Unbalanced Budget Journal Report- Not Supported: Reserved For Future Use IGI Standing Charges: Preliminary Invoice Register- Not Supported: Reserved For Future Use IGI Standing Charges: Listing- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: