总账追溯内往

内往查询总账凭证[@more@]SELECT distinct gh.attribute9 je_number --凭证编号
-- substr(gh.attribute9, length(gh.attribute9) - 10, 11)
FROM gl.gl_je_headers gh, gl.gl_import_references gir --,
--gl_iea_transactions gt
WHERE gh.ACTUAL_FLAG = 'A'
and gh.je_source = 'Intercompany'
and gh.REVERSED_JE_HEADER_ID is null
and gh.je_header_id = gir.je_header_id
and gir.reference_2 ='317643'-- get je_number from iea_transaction .
SELECT distinct gh.attribute9 je_number --凭证编号
-- substr(gh.attribute9, length(gh.attribute9) - 10, 11)
FROM gl.gl_je_headers gh, gl.gl_import_references gir --,
--gl_iea_transactions gt
WHERE gh.ACTUAL_FLAG = 'A'
and gh.je_source = 'Intercompany'
and gh.REVERSED_JE_HEADER_ID is null
and gh.je_header_id = gir.je_header_id
and gir.reference_2 ='317643'-- iea_transaction_id

-- get iea_transaction from je_batch name .
SELECT distinct gh.attribute9 je_number, --凭证编号
gir.reference_2 ,
git.*
-- substr(gh.attribute9, length(gh.attribute9) - 10, 11)
FROM gl.gl_je_headers gh, gl.gl_import_references gir ,--,
gl.gl_je_batches jb ,
gl.gl_iea_transactions git
WHERE gh.ACTUAL_FLAG = 'A'
and gh.je_source = 'Intercompany'
and gh.REVERSED_JE_HEADER_ID is null
and gh.je_header_id = gir.je_header_id
and gir.reference_2= git.transaction_id
-- and gir.reference_2 ='317643'-- iea_transaction_id
and jb.je_batch_id= gh.je_batch_id
and jb.name ='公司间 50129777: A 1472291'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/226700/viewspace-1056126/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/226700/viewspace-1056126/