{"id":308,"date":"2009-10-14T11:34:50","date_gmt":"2009-10-14T09:34:50","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=308"},"modified":"2010-06-07T11:25:06","modified_gmt":"2010-06-07T09:25:06","slug":"sql-wyciaga-zlecenia-ktore-maja-ustawiony-harmonogram","status":"publish","type":"post","link":"http:\/\/oracle.malin.pl\/?p=308","title":{"rendered":"sql &#8211; wyci\u0105ga zlecenia, kt\u00f3re maj\u0105 ustawiony harmonogram"},"content":{"rendered":"<pre lang=\"oracle11\" line=\"1\"> select t.Program,\r\n       t.Requested_Start_Date,\r\n       u.user_name,\r\n       u.description,\r\n       t.Argument_Text\r\n  from apps.fnd_conc_requests_form_v t, fnd_user u\r\n where t.sch_curr_values is not null\r\n   and sysdate <\r\nt.Requested_Start_Date and u.user_id = t.Requested_By<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>select t.Program, t.Requested_Start_Date, u.user_name, u.description, t.Argument_Text from apps.fnd_conc_requests_form_v t, fnd_user u where t.sch_curr_values is not null and sysdate < t.Requested_Start_Date and u.user_id = t.Requested_By\n<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[40,5],"tags":[225,226],"_links":{"self":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/308"}],"collection":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=308"}],"version-history":[{"count":4,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/308\/revisions"}],"predecessor-version":[{"id":333,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/308\/revisions\/333"}],"wp:attachment":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=308"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}