WIE_SOURCE_SYSTEMS_V

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name
SOURCE_SYSTEM_TYPE SOURCE_SYSTEM_ID SOURCE_SYSTEM_CODE SOURCE_SYSTEM_NAME SOURCE_SYSTEM_DESCRIPTION

Query

SQL_Statement

select 'INTERNAL' source_system_type, fa.application_id source_system_id, fa.product_code source_system_code, fa.application_name source_system_name, fa.description source_system_description from fnd_application_vl fa union select 'EXTERNAL' source_system_type, hos.orig_system_id source_system_id, hos.orig_system source_system_code, hos.orig_system_name source_system_name, hos.description source_system_description from hz_orig_systems_vl hos where hos.status = 'A' and hos.start_date_active <= TRUNC(sysdate) and (hos.end_date_active IS NULL or hos.end_date_active >= TRUNC(sysdate)) order by 1, 3