AR 发票号码 sequence

the categor in the GL is related to the transacation  type  in AR

assign the sequence to the relate AR transaction type in GL

begin
Dbms_application_info.set_client_info(84);
end;

Select * from RA_CUST_TRX_TYPES 
 where  CUST_TRX_TYPE_ID=1101

SELECT *
  FROM apps.fnd_doc_sequence_assignments
 WHERE category_code = 'PB_PAR_INV_2' --invoice type
   AND set_of_books_id = 5
   AND creation_date > SYSDATE - 100
   
SELECT *
  FROM apps.fnd_document_sequences
 WHERE doc_sequence_id IN (4520)