{"id":6329,"date":"2017-11-02T12:55:29","date_gmt":"2017-11-02T17:55:29","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=6329"},"modified":"2017-11-02T12:55:29","modified_gmt":"2017-11-02T17:55:29","slug":"peoplesoft-printing-balance-sheet-tree","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2017\/11\/02\/peoplesoft-printing-balance-sheet-tree\/","title":{"rendered":"Peoplesoft &#8211; Printing Balance sheet tree"},"content":{"rendered":"<pre>\r\nwith mytree as\r\n  (select distinct tnode.tree_name, tnode.parent_node_num, tnode.tree_node_num,\r\n          tnode.tree_node, tlvl.tree_level, glacct.account,\r\n          glacct.account_type, tnode.parent_node_name, glacct.descr\r\n     from sysadm.pstreenode tnode,\r\n          sysadm.pstreeleaf tleaf,\r\n          sysadm.ps_gl_account_tbl glacct,\r\n          sysadm.pstreelevel tlvl\r\n     where tnode.setid=tleaf.setid\r\n       and tnode.tree_name=tleaf.tree_name\r\n       and tnode.effdt=tleaf.effdt\r\n       and tleaf.tree_node_num between tnode.tree_node_num and tnode.tree_node_num_end\r\n       and glacct.account between tleaf.range_from and tleaf.range_to\r\n       and tnode.setid=tlvl.setid\r\n       and tnode.tree_name=tlvl.tree_name\r\n       and tnode.tree_level_num=tlvl.tree_level_num\r\n       and tnode.tree_name = 'XPRS_COA')\r\n  --select tree_name, parent_node_name, tree_node, tree_level, account, account_type, level, lpad(descr,length(descr) + level * 2 - 2,'-')\r\n  select lpad(descr,length(descr) + level * 2 - 2,'-')\r\n    from mytree\r\n    start with parent_node_num = 1250000000\r\n    connect by prior tree_node_num = parent_node_num\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>with mytree as (select distinct tnode.tree_name, tnode.parent_node_num, tnode.tree_node_num, tnode.tree_node, tlvl.tree_level, glacct.account, glacct.account_type, tnode.parent_node_name, glacct.descr from sysadm.pstreenode tnode, sysadm.pstreeleaf tleaf, sysadm.ps_gl_account_tbl glacct, sysadm.pstreelevel tlvl where tnode.setid=tleaf.setid and tnode.tree_name=tleaf.tree_name and tnode.effdt=tleaf.effdt and tleaf.tree_node_num between tnode.tree_node_num and tnode.tree_node_num_end and glacct.account between tleaf.range_from and&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2017\/11\/02\/peoplesoft-printing-balance-sheet-tree\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[37,19,22,40],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/6329"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=6329"}],"version-history":[{"count":1,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/6329\/revisions"}],"predecessor-version":[{"id":6330,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/6329\/revisions\/6330"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=6329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=6329"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=6329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}