IGI Range Code Listing - draft

Description
Categories: BI Publisher, Financials
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
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
Chart of Accounts ID
 
LOV Oracle
Data Access Set ID
 
Number
Ledger ID
 
LOV Oracle