IGI Subledger Security: Object Status - draft

Description
Categories: BI Publisher, Financials
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
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
Secure Table Name
 
Owner
 
LOV Oracle
Ask a question