Is there a query to check at supplier site and header level for the File Attachment type based on PO

Oracle EBS Version: 12.1.3

I am trying to establish a case statement that will automatically attach a document to a PO based on the attachment type at the supplier and header level. Basically if the Category Name and attachment type = File, then the document should be automatically attached to the PO.

I was considering having the case condition involve matching the po_header_id with the fnd_attached_documents pk1_value but im not sure if that works.

If those conditions do not match then the PO would just default to another document.

Any help is appreciated.

Thanks,