IGI Profile Code Listing - draft

Description
Categories: BI Publisher, Financials
Application: Public Sector Financials International
Source: Budgeting: Profile Code Listing (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBPCR_XML
DB package: IGI_IGIGBPCR_XMLP_PKG
SELECT  
	distinct igi.profile_code, 
	igi.description, 
	igi.start_date_active,
	igi.end_date_active,  
	prof.period_ratio,   
	gp.entered_period_name, 
	gsob.name, 
	period_year, 
	period_num
FROM 	igi_bud_profile_codes igi, 
	igi_bud_profile_periods prof,  
	gl_periods gp, 
	gl_sets_of_books gsob
WHERE 	igi.set_of_books_id = :p_sob_id
AND 	igi.profile_code = prof.profile_code
AND 	gp.period_set_name = gsob.period_set_name
AND 	gp.period_type = gsob.accounted_period_type
AND	gsob.set_of_books_id = igi.set_of_books_id  
AND	gsob.set_of_books_id = prof.set_of_books_id
AND	gp.period_num = prof.period_number
AND	gp.period_year =  (select max(period_year) 
   		      	from gl_periods
		      	where period_set_name = gsob.period_set_name)
ORDER BY 
	profile_code , period_year, period_num
Parameter Name SQL text Validation
Data Access Set ID
 
Number
Ledger ID
 
LOV Oracle