SELECT<\/p>\n
\u00a0 pah.action_code ,<\/p>\n
\u00a0 pah.object_id ,<\/p>\n
\u00a0 pah.action_date ,<\/p>\n
\u00a0 pah.sequence_num,<\/p>\n
\u00a0 pah.creation_date ,<\/p>\n
\u00a0 prha.segment1 req_num ,<\/p>\n
\u00a0 prha.wf_item_key ,<\/p>\n
\u00a0 prha.authorization_status ,<\/p>\n
\u00a0 fu.description ,<\/p>\n
\u00a0 papf.full_name hr_full_name ,<\/p>\n
\u00a0 papf.employee_number emp_no ,<\/p>\n
\u00a0 pj.NAME job<\/p>\n
FROM<\/p>\n
\u00a0 po.po_action_history pah ,<\/p>\n
\u00a0 po.po_requisition_headers_all prha ,<\/p>\n
\u00a0 applsys.fnd_user fu ,<\/p>\n
\u00a0 hr.per_all_people_f papf ,<\/p>\n
\u00a0 hr.per_all_assignments_f paaf ,<\/p>\n
\u00a0 hr.per_jobs pj<\/p>\n
WHERE<\/p>\n
\u00a0 object_id\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0= prha.requisition_header_id<\/p>\n
AND pah.employee_id\u00a0 \u00a0= fu.employee_id<\/p>\n
AND fu.employee_id\u00a0 \u00a0 = papf.person_id<\/p>\n
AND papf.person_id\u00a0 \u00a0 = paaf.person_id<\/p>\n
AND paaf.job_id\u00a0 \u00a0 \u00a0 \u00a0= pj.job_id<\/p>\n
AND paaf.primary_flag = ‘Y’<\/p>\n
AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date<\/p>\n
AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date<\/p>\n
AND pah.object_type_code = ‘REQUISITION’<\/p>\n
AND prha.segment1\u00a0 \u00a0 \u00a0 \u00a0 =’301000201234′<\/p>\n
\u00a0 –AND pah.action_code = ‘APPROVE’a<\/p>\n
ORDER BY pah.sequence_num;<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"
SELECT \u00a0 pah.action_code , \u00a0 pah.object_id , \u00a0 pah.action_date , \u00a0 pah.sequence_num, \u00a0 pah.creation_date , \u00a0 prha.segment1 req_num , \u00a0 prha.wf_item_key , \u00a0 prha.authorization_status ,… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,127,124,120,121],"tags":[],"class_list":["post-19050","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-applications","category-database","category-oracle-ebs-funcional","category-oracle_ebs_tecnico"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/19050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19050"}],"version-history":[{"count":1,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/19050\/revisions"}],"predecessor-version":[{"id":19051,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/19050\/revisions\/19051"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}