IFS系统表

TABLE & VIEWNOTEREPORT_SYS_TAB报表标题REPORT_SYS_LAYOUT_TAB报表打印格式REPORT_SYS_COLUMN_TAB报表字段及报表参数　　FND_TAB_COMMENTS表注释FND_COL_COMMENTS表中列注释FND_LICENSELICENSE状况

 

删除报表标题：只需找到下面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