IGI Reason Code Listing - draft
Description
Categories: BI Publisher
Columns: Reason Code, Description, Set Of Books Id, Start Date Active, End Date Active, Name ...
Columns: Reason Code, Description, Set Of Books Id, Start Date Active, End Date Active, Name ...
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
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 | |
---|---|---|---|
Ledger ID |
|
LOV Oracle | |
Data Access Set ID |
|
Number |