{"id":890,"date":"2012-09-19T14:43:43","date_gmt":"2012-09-19T12:43:43","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=890"},"modified":"2012-09-19T14:43:43","modified_gmt":"2012-09-19T12:43:43","slug":"useful-function-to-get-quickly-lookup-code-meaning-arpt_sql_func_util-get_lookup_meaning","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=890","title":{"rendered":"Useful function to get quickly lookup code meaning &#8211; ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING"},"content":{"rendered":"<p>You can use EBS build in function to get lookup code meaning<\/p>\n<p>ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING(&#8217;LOOKUP_TYPE&#8217;, LOOKUP_CODE)<!--more--><\/p>\n<p>Example:<\/p>\n<pre lang=\"sql\">SELECT\r\n CR.CREDIT_REQUEST_ID,\r\n CR.CREATION_DATE,\r\n CR.APPLICATION_NUMBER,\r\n ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_CMGT_REVIEW_TYPE', CR.REVIEW_TYPE) typ_wniosku,\r\n ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_CMGT_APPLICATION_STATUS', CR.STATUS) XX_STATUS_WNIOSKU,\r\nFROM AR_CMGT_CREDIT_REQUESTS CR<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>You can use EBS build in function to get lookup code meaning ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING(&#8217;LOOKUP_TYPE&#8217;, LOOKUP_CODE)<\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[40,88],"tags":[161,160,72],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/890"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=890"}],"version-history":[{"count":1,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/890\/revisions"}],"predecessor-version":[{"id":891,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/890\/revisions\/891"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}