IGI Subledger Security: Secure Tables Status - draft
Description
Categories: BI Publisher
Application: Public Sector Financials International
Source: Subledger Security: Secure Tables Status Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGISLSST_XML
DB package: IGI_IGISLSST_XMLP_PKG
Source: Subledger Security: Secure Tables Status Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGISLSST_XML
DB package: IGI_IGISLSST_XMLP_PKG
Run
IGI Subledger Security: Secure Tables Status - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT t.owner owner, t.table_name table_name2, t.table_name||' - '|| t.description table_name_desc, t.sls_table_name, t.update_allowed, t.date_enabled date_enabled2, t.date_disabled date_disabled2, t.date_removed date_removed2, to_char(t.date_enabled,'DD-MON-YYYY HH24:MI:SS') date_enabled2_c, to_char(t.date_disabled,'DD-MON-YYYY HH24:MI:SS') date_disabled2_c, to_char(t.date_removed,'DD-MON-YYYY HH24:MI:SS') date_removed2_c, IGI_IGISLSST_XMLP_PKG.cf_1formula(t.owner) CF_1 FROM igi_sls_secure_tables t WHERE t.owner like :P_OWNER_T AND t.table_name like :P_TABLE_NAME_T UNION SELECT d.owner owner, d.table_name table_name2, d.table_name||' - '|| d.description table_name_desc, d.sls_table_name, d.update_allowed, d.date_enabled date_enabled2, d.date_disabled date_disabled2, d.date_removed date_removed2, to_char(d.date_enabled,'DD-MON-YYYY HH24:MI:SS') date_enabled2_c, to_char(d.date_disabled,'DD-MON-YYYY HH24:MI:SS') date_disabled2_c, to_char(d.date_removed,'DD-MON-YYYY HH24:MI:SS') date_removed2_c, IGI_IGISLSST_XMLP_PKG.cf_1formula(d.owner) CF_1 FROM igi_sls_deleted_tables_v d WHERE d.owner like :P_OWNER_T AND d.table_name like :P_TABLE_NAME_T ORDER BY owner, table_name2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Owner |
|
LOV Oracle | |
Secure Table Name |
|
Char |