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
Source: Subledger Security: Object Status Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGISLSOS_XML
DB package: IGI_IGISLSOS_XMLP_PKG
Run
IGI Subledger Security: Object Status - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Owner |
|
LOV Oracle | |
Secure Table Name |
|
Char |