DOC_SEQUENCE_QRY

/* Formatted on 17-09-2011 13:31:52 (QP5 v5.115.810.9015) */
SELECT   seq.NAME,
         seq.db_sequence_name,
         seq.initial_value,
         ds.LAST_NUMBER,
         seq.table_name,
         seq.start_date,
         seq.end_date,
         app.APPLICATION_SHORT_NAME,
         DECODE (asgn.METHOD_CODE,
                 'A',
                 'Automatic',
                 'M',
                 'Manual')
            Method,
         cat.CODE Category
  FROM   FND_DOCUMENT_SEQUENCES seq,
         fnd_Application app,
         FND_DOC_SEQUENCE_CATEGORIES cat,
         FND_DOC_SEQUENCE_ASSIGNMENTS asgn,
         dba_sequences ds
 WHERE       app.application_id = seq.application_id
         AND asgn.DOC_SEQUENCE_ID = seq.DOC_SEQUENCE_ID
         AND cat.code = asgn.CATEGORY_CODE
         AND ds.SEQUENCE_NAME = seq.DB_SEQUENCE_NAME

--Select *  from  dba_sequences