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
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
Run
IGI Profile Code Listing- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |