POI_DATASETS_V

Details

• Schema: FUSION

• Object owner: POI

• Object type: VIEW

Columns

Name
DATASET_NAME DISPLAY_NAME DATASET_PURPOSE LAST_USED_DATE ENTITY_ID

Query

SQL_Statement

SELECT dataset_name , Nvl(meaning,dataset_name) display_name, purpose dataset_purpose, last_used_date, entity_id 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, DECODE(lookup_code,'ORA_POI_ESG_INVOICES',2,1) FROM fnd_lookup_values_vl WHERE lookup_type = 'ORA_POI_DATASETS' AND lookup_code not IN ( SELECT dataset_name FROM POI_dataset_headers )