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
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
Blitz Report™