IGI Subledger Security: Secure Tables Status - draft

Description

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

IGI Subledger Security: Secure Tables Status - draft and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

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