Friday, August 21, 2015

Query to check before Disabling any Accounts in oracle

Below Query will help to see if any transactions are in process/pending if we cant to disable any accounts in oracle  

SELECT *
  FROM xla_ae_headers xah, xla_ae_lines xal
 WHERE 1 = 1
   AND xal.ae_header_id = xah.ae_header_id
   AND xah.gl_transfer_status_code = 'N'
   AND xal.code_combination_id IN (
          SELECT code_combination_id
            FROM gl_code_combinations_kfv
           WHERE segment3 IN
                    (500101,
                     500111,
                     800161,
                     800201,
                     850101,
                     850121,
                     850141,
                     850161,
                     850231
                    ))

No comments: