{"id":18203,"date":"2019-04-25T15:33:24","date_gmt":"2019-04-25T18:33:24","guid":{"rendered":"https:\/\/orabr.com\/?p=18203"},"modified":"2019-04-25T15:38:56","modified_gmt":"2019-04-25T18:38:56","slug":"-duvida-oracle-ame-approvals-managment-2","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=18203","title":{"rendered":"D\u00favida Oracle AME (Approvals Managment)"},"content":{"rendered":"

<\/p>\n

 <\/span> <\/p>\n
\n
<\/p>\n
\n

Boa tarde!<\/p>\n

\u00a0<\/p>\n

Se for hierarquia de supervis\u00e3o, pode obter os limites e pessoas com:<\/p>\n

PER_ALL_PEOPLE_F<\/p>\n

PER_ALL_ASSIGNMENTS_F<\/p>\n

PO_CONTROL_RULES<\/p>\n

PO_CONTROL_GROUPS<\/p>\n

PO_POSITION_CONTROLS<\/p>\n

PER_ALL_POSITIONS<\/p>\n

\u00a0<\/p>\n

Se for hierarquia de posi\u00e7\u00e3o, pode acrescentar:<\/p>\n

PER_POSITION_STRUCTURES<\/p>\n

PER_POS_STRUCTURE_VERSIONS_V<\/p>\n

PER_POS_STRUCTURE_ELEMENTS_V<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

Att.,<\/p>\n

Gustavo C. Peix\u00f4to<\/p>\n

Em Qui 25\/04\/19 15:09, Marcelo Macedo marcelo.rmacedo@yahoo.com.br escreveu:<\/p>\n

\u00a0<\/span> <\/p>\n

\n
\n
\n

\u00a0<\/p>\n

\n
Boa tarde pessoal,<\/div>\n
\u00a0<\/div>\n
Um amigo est\u00e1 precisando de uma ajuda, seja a d\u00favida:<\/div>\n
\u00a0<\/div>\n
“Estou precisando fazer um select a partir de um usu\u00e1rio e obter a hierarquia de aprova\u00e7\u00e3o (com o limites para cada um) para cima e para baixo na arvore hier\u00e1rquica do Oracle AME (Approvals Managment).\u00a0<\/em><\/strong> <\/p>\n
Algu\u00e9m poderia ajudar informando quais as tabelas comp\u00f5em estas informa\u00e7\u00f5es?<\/em><\/strong><\/div>\n
\u00a0<\/em><\/strong><\/div>\n
Qualquer sugest\u00e3o \u00e9 bem vinda.\u00a0<\/em><\/strong><\/div>\n
\u00a0<\/em><\/strong><\/div>\n
Grato”<\/em><\/strong><\/div>\n
\u00a0<\/div>\n
\u00a0<\/div>\n
\u00a0<\/div>\n
ats,<\/div>\n
\u00a0<\/div>\n
Marcelo Macedo<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/div>\n<\/p><\/div>\n<\/div>\n<\/blockquote>\n<\/p><\/div>\n

<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"

  Boa tarde! \u00a0 Se for hierarquia de supervis\u00e3o, pode obter os limites e pessoas com: PER_ALL_PEOPLE_F PER_ALL_ASSIGNMENTS_F PO_CONTROL_RULES PO_CONTROL_GROUPS PO_POSITION_CONTROLS PER_ALL_POSITIONS \u00a0 Se for… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-18203","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18203","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=18203"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18203\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}