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

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
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
Imported from BI Publisher
BUD: Budgeting: Range Code Listing

SQL 17 lines

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

Parameters 1

ParameterTypeList of values SQL
Ledger IDLOV Oracle