IGI Subledger Security: Group Status - draft

Description

Application: Public Sector Financials International
Source: Subledger Security: Group Status Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGISLSSG_XML
DB package: IGI_IGISLSSG_XMLP_PKG

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

Copy

SELECT
			  g.sls_group         sec_name,
              g.description        sec_desc,
              g.date_enabled    sec_dt_enabled,
              g.date_disabled   sec_dt_disabled,
              g.date_removed   sec_dt_removed,
              to_char(g.date_enabled,'DD-MON-YYYY  HH24:MI:SS')    sec_dt_enabled_c,
              to_char(g.date_disabled,'DD-MON-YYYY  HH24:MI:SS')   sec_dt_disabled_c,
              to_char(g.date_removed,'DD-MON-YYYY  HH24:MI:SS')   sec_dt_removed_c,
	IGI_IGISLSSG_XMLP_PKG.cf_2formula(g.sls_group) CF_2
FROM     igi_sls_groups g
WHERE   g.sls_group_type = 'S'
AND       (:P_GROUP_TYPE_T = 'S' OR :P_GROUP_TYPE_T = '%')
AND       g.sls_group  LIKE :P_GROUP_NAME_T
AND g.sls_group != 'CEN'
UNION
SELECT
 			  dg.sls_group         sec_name,
              dg.description        sec_desc,
              dg.date_enabled    sec_dt_enabled,
              dg.date_disabled   sec_dt_disabled,
              dg.date_removed   sec_dt_removed,
              to_char(dg.date_enabled,'DD-MON-YYYY  HH24:MI:SS')    sec_dt_enabled_c,
              to_char(dg.date_disabled,'DD-MON-YYYY  HH24:MI:SS')   sec_dt_disabled_c,
              to_char(dg.date_removed,'DD-MON-YYYY  HH24:MI:SS')   sec_dt_removed_c,
	IGI_IGISLSSG_XMLP_PKG.cf_2formula(dg.sls_group) CF_2
FROM     igi_sls_deleted_groups_v dg
WHERE   dg.sls_group_type = 'S'
AND       (:P_GROUP_TYPE_T = 'S' OR :P_GROUP_TYPE_T = '%')
AND   dg.sls_group != 'CEN'
AND       dg.sls_group  LIKE :P_GROUP_NAME_T
ORDER BY sec_name