Procurement - EBS (MOSC)

MOSC Banner

Open purchase orders

edited Nov 25, 2015 10:06AM in Procurement - EBS (MOSC) 1 commentAnswered

Hello Experts


We are going live with EDI in couple of weeks time and now struck with the query to retrieve the open purchase orders.

The process is we send the purchase orders to Tradex HUB and the hub accepts only those invocies which are against the open valid purchase orders. In the HUB they do not have the provision to store the header and line status hence we came up with a workaround to concatenate PO header and line status. We wrote the below query but it is not retrieving the right results. Can you please look into the below and let me know if there is any thing wrong

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