Technology Stack - EBS (MOSC)

MOSC Banner

query in the Open Orders and Lines report doesn't pick up PO number with new Sales Order line status

edited May 31, 2013 1:02AM in Technology Stack - EBS (MOSC) 1 commentAnswered
Hello Friends,

The query in the Open Orders and Lines report doesn't pick up PO number with new Sales Order line status which is PO_OPEN.

Actually the query picks up the PO Number but it omits the Po number for the SO line which has a status as PO_OPEN.

We nee to include a condition to pick up the PO Number for this new status as well.

Please advise.I have attached the Query as well.

Kind Regards

Siva Charan


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