PO Report - How to bring Blanket purchase agreement column using SQL Query in BI Publisher

Reddy-87640

Summary

Need to bring Blanket Purchase agreement column in BI Publisher report

Content

Hi,

I have PO Report and need to bring Blanket purchase agreement column in Bi Publisher PO Report. which tables i need to join to bring the balnket purchase agreement number. can any one help me how to get that column in sql query. based on PO number, need to show the BPA number in BIP Report.

Thanks,

Sudhakar