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

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Ledger ID
 
LOV Oracle