Procurement - EBS (MOSC)

MOSC Banner

PO Approval Name and Date

edited Apr 15, 2015 3:12PM in Procurement - EBS (MOSC)

I have below code working for STANDARD PO and it gets the APPROVAL NAME and APPROVAL DATE.

I would like the same code to be used to get the APPROVAL NAME and APPROVAL DATE for Blanket "RELEASE". Please suggest how this can be done.

  CPD_PO_HEADERS_PRINT              table has column PO_RELEASE_ID.

SELECT  decode(:P_sortby, 'PO NUMBER', null, poh.document_buyer_last_name)
,        decode(:P_sortby, 'PO NUMBER', null, poh.document_buyer_first_name)
,        decode(:po_num_type,'NUMERIC', null, poh.po_num)
,        decode(:po_num_type,'NUMERIC', decode(rtrim(poh.po_num,'0123456789'),NULL,to_number(poh.po_num),-1), null)

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