查询ORACLE EBS 有哪些接口表

Oracle EBS 接口表：

SELECT *
  FROM dba_objects db
 WHERE db.object_type = 'TABLE'
   AND db.object_name LIKE '%INTERFACE%';

SELECT *
  FROM dba_objects db
 WHERE db.object_type = 'TABLE'
   AND db.object_name LIKE '%INTERFACE%'
   AND owner LIKE 'PO';

 

查询表中字段的类型

 SELECT a.column_id, a.column_name, a.data_type data_type, a.nullable, a.table_name
  FROM cols a
 WHERE 1 = 1
   AND a.data_type = 'DATE'
   AND a.table_name = 'PO_REQUISITION_HEADERS_ALL'
 ORDER BY a.column_id; --po