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
))
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:
Post a Comment