IFS系统表

TABLE & VIEW	NOTE
REPORT_SYS_TAB	报表标题
REPORT_SYS_LAYOUT_TAB	报表打印格式
REPORT_SYS_COLUMN_TAB	报表字段及报表参数
FND_TAB_COMMENTS	表注释
FND_COL_COMMENTS	表中列注释
FND_LICENSE	LICENSE状况

 

删除报表标题：只需找到下面3个系统表，把对应的Report ID 的记录删除即可
Report_Sys_Tab
report_sys_layout_tab
report_sys_column_tab

 

===============================

SELECT * FROM Dba_Tables d
WHERE d.table_name LIKE '%SYS%'
AND   d.owner = 'IFSAPP'
----------------------------
OWNER TABLE_NAME
IFSAPP BATCH_SYS_TAB
IFSAPP CFA_SYSTEM_PARAMETER_TAB
IFSAPP DATABASE_SYS_ORACLE_INDEX_TAB
IFSAPP DICTIONARY_SYS_METHOD_TAB
IFSAPP DICTIONARY_SYS_PACKAGE_TAB
IFSAPP DICTIONARY_SYS_TAB
IFSAPP DICTIONARY_SYS_VIEW_TAB
IFSAPP FA_SYSTEM_PARAMETER_TAB
IFSAPP FNDEXT_MOD_SYS_DOC
IFSAPP FNDEXT_SYS_COMP_CONFIG
IFSAPP LANGUAGE_SYS_IMP_TAB
IFSAPP LANGUAGE_SYS_TAB
IFSAPP MPCCOM_SYSTEM_PARAMETER_TAB
IFSAPP OBJECT_CONNECTION_SYS_TAB
IFSAPP PRINT_SERVER_SYS_TAB
IFSAPP REFERENCE_SYS_TAB
IFSAPP REPORT_SYS_COLUMN_TAB
IFSAPP REPORT_SYS_GROUP_COLUMN_TAB
IFSAPP REPORT_SYS_GROUP_TAB
IFSAPP REPORT_SYS_LAYOUT_TAB
IFSAPP REPORT_SYS_TAB
IFSAPP REPORT_SYS_TEXT_TAB
IFSAPP SECURITY_SYS_PRIVS_TAB
IFSAPP SECURITY_SYS_ROLE_PRIVS_TAB
IFSAPP SECURITY_SYS_RPRIVS_COPY_TAB
IFSAPP SECURITY_SYS_TAB
IFSAPP TRANSACTION_SYS_LOCAL_TAB
IFSAPP TRANSACTION_SYS_STATUS_TAB
IFSAPP USER_PROFILE_ENTRY_SYS_TAB
IFSAPP USER_PROFILE_SYS_TAB

 

 

=

SELECT * FROM All_Views a
WHERE a.view_name LIKE '%SYS%'
AND   a.owner = 'IFSAPP'

-------------------------------------

OWNER VIEW_NAME
IFSAPP CFA_SYSTEM_PARAMETER
IFSAPP DICTIONARY_SYS_METHOD_LOV
IFSAPP FA_SYSTEM_PARAMETER
IFSAPP MPCCOM_SYSTEM_PARAMETER
IFSAPP MPCCOM_SYSTEM_PARAMETER_COPC
IFSAPP MPCCOM_SYSTEM_PARAMETER_GYN
IFSAPP MPCCOM_SYSTEM_PARAMETER_GYNA