Write a report to fetch list of PO attachment under different categories
Summary:
SQL to fetch
Content (please ensure you mask any confidential information):
PO attachment under some categories (e.g. to buyer) are visible to supplier but not intended.
Business would like a report to check which PO has attachment and under what categories ('TO_SUPPLIER', 'TO_APPROVER','MISC', 'FROM_SUPPLIER', 'PO_INTERNAL', 'TO_BUYER', 'TO_PAYABLES','TO_RECEIVER') at both PO header level and PO line level.
- Please share SQL for extraction.
- How to control PO attachment under 'To buyer' to be INVISIBLE to suppliers
Version (include the version you are using, if applicable):
25B
Code Snippet (add any code snippets that support your topic, if applicable):