You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

How can the BPA related to an EPP line be reported/queried.

edited Jan 15, 2025 2:36PM in Purchasing 3 comments

Summary:

Trying to write a report/query that includes the related Agreement (BPA) line - as is displayed in the UI. What table is this stored in or how is the relationship maintained to the BPA lines.

The table being queried:

SCH_EPP_HEADERS

SCH_EPP_LINES

How to either identify the related BPA lines (I don't see a reference) or join to PO/BPA tables for that information.

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

25D


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!