IGI Reason Code Listing - draft

Description
Categories: BI Publisher, Financials
Application: Public Sector Financials International
Source: Budgeting: Reason Code Listing (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBRCR_XML
DB package: IGI_IGIGBRCR_XMLP_PKG
select  reason_code, je.description, je.set_of_books_id, start_date_active, end_date_active, name
from igi_bud_reason_codes je,  gl_sets_of_books gl
WHERE  je.set_of_books_id = gl.set_of_books_id
and  je.SET_OF_BOOKS_ID = :P_SOB_ID
ORDER BY  upper(reason_code)
Parameter Name SQL text Validation
Data Access Set ID
 
Number
Ledger ID
 
LOV Oracle