機械翻訳について

WIE_SOURCE_SYSTEMS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: WIE

• オブジェクト・タイプ: VIEW

列

名前
SOURCE_SYSTEM_TYPE SOURCE_SYSTEM_ID SOURCE_SYSTEM_CODE SOURCE_SYSTEM_NAME SOURCE_SYSTEM_DESCRIPTION

問合せ

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