Procurement - EBS (MOSC)

MOSC Banner

Where can I find the tables in the buyer work center > Orders?

edited May 8, 2019 5:05AM in Procurement - EBS (MOSC) 14 commentsAnswered

I want to run a query that looks similar to below : (this is in Purchasing > Buyer work Center> Orders)

But I can't even start my query without the correct tables! I first queried the blanket purchase agreement number using the table name po_headers_all.

I then obtained the po_header_id and used that information to try to get similar results below.

I tried the table names:

po_line_locations_all

po_lines_all

po_requisition_lines_all

po_lines

po_req_distribution_all

I know this is a dumb question and a simple query.... Any help is much appreciated!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center