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 |