IGI Range Code Listing- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: BUD: Budgeting: Range Code Listing
Application: Public Sector Financials International
Source: Budgeting: Range Code Listing (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBRCL_XML
DB package: IGI_IGIGBRCL_XMLP_PKG
Description: BUD: Budgeting: Range Code Listing
Application: Public Sector Financials International
Source: Budgeting: Range Code Listing (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBRCL_XML
DB package: IGI_IGIGBRCL_XMLP_PKG
Run
IGI Range Code Listing- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT codes.RANGE_CODE, codes.DESCRIPTION, codes.START_DATE_ACTIVE, codes.END_DATE_ACTIVE, gsob.NAME SOB_NAME, &CP_FLEX_LOW LOW_RANGE, &CP_FLEX_HIGH HIGH_RANGE FROM IGI_BUD_RANGE_CODES codes, IGI_BUD_CODE_RANGES ranges, GL_SETS_OF_BOOKS gsob WHERE ranges.RANGE_CODE = codes.RANGE_CODE AND ranges.SET_OF_BOOKS_ID = codes.SET_OF_BOOKS_ID AND ranges.SET_OF_BOOKS_ID = :P_SOB AND nvl(codes.REPORT_RANGE_FLAG,'N') != 'Y' AND gsob.SET_OF_BOOKS_ID = ranges.SET_OF_BOOKS_ID ORDER BY 1, 6 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger ID |
|
LOV Oracle |