Where are Attachment files held for AGIS transactions ?

Hi All,

Attachments are held in fnd_attached_documents table. 

If you wanted to use sql to find the attachment details then you could use the following sql:- 

select * from fun_trx_batches where batch_number = << batch number>> 

select * from fun_trx_headers where batch_id = << from the first query>> 

select * from fnd_attached_documents where pk1_value = <<header id from the second 

query>> 

Thanks

Ravi