IGI Subledger Security: Object Status - draft
Description
- Categories
- BI Publisher
- Application
- Public Sector Financials International
- Source
- Subledger Security: Object Status Report (XML) - Not Supported: Reserved For Future Use
- Short Name
- IGISLSOS_XML
- DB package
- IGI_IGISLSOS_XMLP_PKG
SQL 10 lines
SELECT a.object_name policy_function_name, Initcap(a.status) policy_function_status, b.object_name pol_func_table_name FROM all_objects a, all_policies b WHERE a.object_name = b.function AND b.policy_name like 'IGI_SLS%' AND a.object_type = 'FUNCTION' and b.object_name=:table_name2 |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| Owner | LOV Oracle | |
| Secure Table Name | Char |