Oracle ERP R12. Doc Sequence lose

因最近發現,user在建立Doc Seq.後其Database的sequence有lose
(可能當時資料庫有狀況,導致create sequence失敗),故建立以下
Sql來trace是否有lose的狀況
其SQL_COMMAND則為建立SEQUENCE的語法.

SELECT 'Create sequence APPLSYS.'||A.DB_SEQUENCE_NAME||
       ' minvalue '||A.INITIAL_VALUE||
       ' maxvalue 999999999 '||
       ' start with '||A.INITIAL_VALUE||
       ' increment by 1 '||
       ' nocache;' SQL_COMMAND,
       A.DB_SEQUENCE_NAME,
       B.sequence_name,
       A.NAME,A.INITIAL_VALUE,
       A.TABLE_NAME,A.*
  FROM FND_DOCUMENT_SEQUENCES A
  LEFT JOIN DBA_SEQUENCES B
    ON B.sequence_name = A.DB_SEQUENCE_NAME
 WHERE B.sequence_name IS NULL