{"id":1084,"date":"2014-04-29T11:53:43","date_gmt":"2014-04-29T09:53:43","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1084"},"modified":"2014-04-29T12:21:38","modified_gmt":"2014-04-29T10:21:38","slug":"banki-dostawcow","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1084","title":{"rendered":"Banki dostawc\u00f3w"},"content":{"rendered":"<p>Banki i rachunki bankowe dostawc\u00f3w<\/p>\n<pre lang=\"sql\">\r\n\r\n\r\n\r\nSELECT   s.vendor_name ,\r\n  ss.vendor_site_code ,\r\n  eb.bank_name        ,\r\n  EB.BANK_NAME_ALT    ,\r\n  ebb.bank_branch_name,\r\n  ebb.branch_number   ,\r\n  eba.bank_account_num,\r\n  eba.bank_account_name\r\nFROM ap.ap_suppliers s ,\r\n  ap.ap_supplier_sites_all ss ,\r\n  apps.iby_ext_bank_accounts eba,\r\n  apps.iby_account_owners ao,\r\n  apps.iby_ext_banks_v eb ,\r\n  apps.iby_ext_bank_branches_v ebb\r\nWHERE s.vendor_id                      = ss.vendor_id\r\nAND ao.account_owner_party_id  = s.party_id\r\nAND eba.ext_bank_account_id      = ao.ext_bank_account_id\r\nAND eb.bank_party_id                  = ebb.bank_party_id\r\nAND eba.branch_id                       = ebb.branch_party_id\r\nAND eba.bank_id                         = eb.bank_party_id; \r\n\r\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Banki i rachunki bankowe dostawc\u00f3w SELECT s.vendor_name , ss.vendor_site_code , eb.bank_name , EB.BANK_NAME_ALT , ebb.bank_branch_name, ebb.branch_number , eba.bank_account_num, eba.bank_account_name FROM ap.ap_suppliers s , ap.ap_supplier_sites_all ss , apps.iby_ext_bank_accounts eba, apps.iby_account_owners ao, apps.iby_ext_banks_v eb , apps.iby_ext_bank_branches_v ebb WHERE s.vendor_id = ss.vendor_id AND &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=1084\">Czytaj dalej <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[149],"tags":[218,219],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1084"}],"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=1084"}],"version-history":[{"count":4,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1084\/revisions"}],"predecessor-version":[{"id":1088,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1084\/revisions\/1088"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}