Approved Supplier List Report with BPA that is linked with it

Hi All,

If Business need  ASL Report with whom BPA is attached with it, In R12.1.3 there is no seeded report which gives us ASL along with BPA.

Answer : we will create a custom report or just use SQL to develop the query. You can link the PO_ASL_DOCUMENTS & PO_ASL_ATTRIBUTES TO PO_HEADERS.

You could use the below SQL. it is a simple one and gives the vendor name, the Item, the PO number with the item unit price and the PO date. You need to change the using_organization_id code to suit your requirement

SELECT distinct