---
# System prepended metadata

title: Oracle Fusion ERP 學習筆記
tags: [Oracle, Sandbox, 筆記, Application Composer, Fusion, ERP]

---

如何找到Sandbox的Application Composer，建立Object(Table)來提供Oracle Analytics的Data Model進行資料提供。
```SQL
SELECT table_name
  FROM ADF_EXTENSIBLE_TABLE
 WHERE table_id IN (
   SELECT table_id 
     FROM ADF_EXTENSIBLE_TABLE_USAGE
    WHERE context_column_value = :API_NAME
 )
```
> https://docs.oracle.com/en/cloud/saas/sales/oedms/adfextensibletable-19291.html#adfextensibletable-19291

