Procurement - EBS (MOSC)

MOSC Banner

CLOSED_CODE in Table: PO_REQUISITION_HEADERS_ALL

edited Mar 15, 2018 10:08AM in Procurement - EBS (MOSC) 2 commentsAnswered

I was asked to find all "OPEN" requisitions in my company. I noticed in requisition header table PO_REQUISITION_HEADERS_ALL, the CLOSED_CODE column can be NULL, "OPEN" and "FINALLY CLOSED". What does NULL value for CLOSED_CODE mean? Is the requisition considered open if its CLOSED_CODE is null? what is the difference between NULL and "OPEN" for CLOSED_CODE column ?

Thanks

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