[Oracle]Setup Document Sequences by Dataload

--定義
SELECT FDS.NAME,
       'TAB',
       FAT.APPLICATION_NAME,
       'TAB',
       FDS.START_DATE,
       'TAB',
       FDS.END_DATE,
       'TAB',
       '自動',
       'TAB',
       'TAB',
       FDS.INITIAL_VALUE,
       'TAB',
       'ENT'
  FROM FND_DOCUMENT_SEQUENCES FDS, FND_APPLICATION_TL FAT
 WHERE 1 = 1
   AND FDS.APPLICATION_ID = FAT.APPLICATION_ID
   AND FAT.SOURCE_LANG = 'ZHT'
   AND FDS.NAME LIKE 'XXX%'
   --AND FAT.APPLICATION_NAME = '應付帳款管理系統'
   AND TO_CHAR(FDS.START_DATE, 'YYYY') = '2022'
ORDER BY FDS.NAME;

--指定
SELECT FAT.APPLICATION_NAME,
       'TAB',
       FDSC.NAME,
       'TAB',
       SOB.NAME,
       'TAB',
       'TAB',
       FDSA.START_DATE,
       'TAB',
       FDSA.END_DATE,
       'TAB',
       FDS.NAME,
       'ENT'
  FROM FND_DOCUMENT_SEQUENCES       FDS,
       FND_DOC_SEQUENCE_ASSIGNMENTS FDSA,
       FND_DOC_SEQUENCE_CATEGORIES  FDSC,
       FND_APPLICATION_TL           FAT,
       GL_SETS_OF_BOOKS             SOB
 WHERE 1 = 1
   AND FDS.DOC_SEQUENCE_ID = FDSA.DOC_SEQUENCE_ID
   AND FDSA.APPLICATION_ID = FAT.APPLICATION_ID
   AND FDSA.CATEGORY_CODE = FDSC.CODE
   AND FDSA.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
   AND FAT.SOURCE_LANG = 'ZHT'
   AND SOB.NAME = 'XX'
   --AND FAT.APPLICATION_NAME = '總帳會計管理系統'
   AND TO_CHAR(FDS.START_DATE, 'YYYY') = '2022'
 ORDER BY SOB.NAME,FAT.APPLICATION_NAME, FDSC.NAME, FDSA.START_DATE;