How to find wf_item_type and wf_item_key for a releases?

SELECT hr.NAME, poh.segment1, por.release_num, por.wf_item_type,
  por.wf_item_key
  FROM po_headers_all poh, po_releases_all por, hr_all_organization_units hr
 WHERE poh.org_id = hr.organization_id
  AND por.org_id = poh.org_id
  AND poh.po_header_id = por.po_header_id
  AND poh.segment1 = '796'
  AND por.release_num = '49'

Leave a Reply