SEQUENCE_UPDATE_QUERY

      SEQUENCE_UPDATE_QUERY
---------------------------------------------------------

    STEPS TO CREATE ALTER THE SEQUENCE
-------------------------------------------- -----------------------------------

ALTER SEQUENCE APPLSYS.FND_DOC_SEQ_108_S INCREMENT BY 96;

select  FND_DOC_SEQ_108_S.NEXTVAL from dual;

alter sequence APPLSYS.FND_DOC_SEQ_108_S  increment by 1;

     HOW TO FIND THE SEQUENCE NAME
------------------------------------------------------------------
GO TO SYSTEM ADMIN
        NEXT
     APPLICATION
        NEXT
SEQUENTIAL NUMBERING
        NEXT
       ASSIGN
QUERY MODULE NAME AND CATEGORY
       NEXT
   HELP --> DIG

   HOW TO FIND THE SEQUENCE NAME IN QUERY
------------------------------------------------------------------------------

select * from fnd_document_SEQUENCEs where DOC_SEQUENCE_ID =108 
 
select * from ALL_SEQUENCES where SEQUENCE_NAME = 'FND_DOC_SEQ_108_S'

select * from dba_sequences where SEQUENCE_NAME like 'XXX%'

    GENTORL
-----------------------

select *
from ap_invoices_all
where GL_DATE > '13-AUG-2011'
and INVOICE_TYPE_LOOKUP_CODE = 'STANDARD'
AND SOURCE IN ( 'INDIA TAX INVOICE', 'INDIA TDS','ERS')  
AND DOC_SEQUENCE_VALUE IS  NULL
AND VOUCHER_NUM IS NULL
AND ORG_ID = 90

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

SELECT  max (DOC_SEQUENCE_VALUE)
  FROM   ap_invoices_all
 WHERE   ORG_ID = 90
 and GL_DATE > '13-AUG-2011'
 and INVOICE_TYPE_LOOKUP_CODE = 'STANDARD'
 AND SOURCE IN ( 'INDIA TDS','ERS','INDIA TAX INVOICE')