機械翻訳について

POI_DATASETS_V

詳細

• スキーマ: FUSION

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

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

列

名前
DATASET_NAME DISPLAY_NAME DATASET_PURPOSE LAST_USED_DATE

問合せ

SQL_Statement

SELECT dataset_name , Nvl(meaning,dataset_name) as display_name, purpose dataset_purpose, last_used_date FROM POI_dataset_headers ds, fnd_lookup_values_vl vl WHERE ds.dataset_name = vl.lookup_code(+) AND vl.lookup_type(+) = 'ORA_POI_DATASETS' UNION ALL SELECT lookup_code,meaning,'ORA_POI_CLASSIFICATION', null FROM fnd_lookup_values_vl WHERE lookup_type = 'ORA_POI_DATASETS' AND lookup_code not IN ( SELECT dataset_name FROM POI_dataset_headers )