{"id":1080,"date":"2014-02-21T17:52:09","date_gmt":"2014-02-21T15:52:09","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1080"},"modified":"2014-05-07T16:45:14","modified_gmt":"2014-05-07T14:45:14","slug":"siedziby-klientow-po-nip","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1080","title":{"rendered":"Siedziby klient\u00f3w \/ dostawc\u00f3w po NIP"},"content":{"rendered":"<p>Gdy przy rejestracji klienta lub dostawcy pojawia enigmatyczny, nic nie m\u00f3wi\u0105cy komunikat:<\/p>\n<pre>\u201eTen NIP jest ju\u017c u\u017cywany dla typu podmiotu: Siedziba podmiotu trzeciego, nazwy podmiotu xxxx i siedziby podmiotu xxxxx.\u201d<\/pre>\n<p>To wcale nie znaczy, \u00a0\u017ce zduplikowany NIP na siedzibie wymienionej w komunikacie, poza tym ci\u0119\u017cko jednoznacznie zidentyfikowa\u0107 t\u0119 siedzib\u0119 &#8211; nie wiadomo czy to klient czy dostawca.<\/p>\n<p>Pomocny skrypt:<\/p>\n<pre lang=\"sql\">\r\n\r\nWITH party as \r\n    (    \r\n    select p.party_name, p.party_id, p.party_number, ps.party_site_id, ps.party_site_number from hz_parties p, HZ_PARTY_SITES ps\r\n    where p.party_id=ps.party_id\r\n    and  UPPER (p.party_name) LIKE UPPER ('%&name%')\r\n--    and p.party_id = 2668654\r\n    ),\r\n    \r\n nip as\r\n (\r\n SELECT ZP.REP_REGISTRATION_NUMBER, zp.party_id, zp.PARTY_TYPE_CODE\r\n FROM ZX_PARTY_TAX_PROFILE zp\r\n  WHERE UPPER (ZP.REP_REGISTRATION_NUMBER) LIKE UPPER ('%&NIP%')\r\n-- where zp.party_id=2668654\r\n--where zp.last_update_date > sysdate - 1\/24\r\n )\r\n\r\nselect pu.party_usage_code, p.party_name, p.party_id, p.party_number, null site_id, null site_number, n.REP_REGISTRATION_NUMBER, n.party_id party_id_TAX_PROFILE, n.PARTY_TYPE_CODE\r\nfrom party p, nip n, hz_party_usg_assignments pu\r\nwhere  1=1\r\n--  \/* party_id w ZX_PARTY_TAX_PROFILE dla THIRD_PARTY to PARTY_ID w HZ_PARTIES *\/\r\n    and n.PARTY_TYPE_CODE =  'THIRD_PARTY' \r\n    and n.PARTY_ID = p.PARTY_ID \r\n    and rownum=1\r\n    and n.PARTY_ID = pu.PARTY_ID(+)\r\nunion all\r\n\r\nselect pu.party_usage_code, p.party_name, p.party_id, p.party_number, p.party_site_id, p.party_site_number, n.REP_REGISTRATION_NUMBER, n.party_id party_id_TAX_PROFILE, n.PARTY_TYPE_CODE\r\nfrom party p, nip n,  hz_party_usg_assignments pu\r\nwhere  1=1\r\n\r\n--  \/* party_id w ZX_PARTY_TAX_PROFILE dla THIRD_PARTY_SITE to PARTY_SITE_ID w HZ_PARTY_SITES *\/\r\n and n.PARTY_TYPE_CODE =  'THIRD_PARTY_SITE' \r\n and n.PARTY_ID = p.PARTY_SITE_ID\r\n and n.PARTY_ID = pu.PARTY_ID(+)\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Gdy przy rejestracji klienta lub dostawcy pojawia enigmatyczny, nic nie m\u00f3wi\u0105cy komunikat: \u201eTen NIP jest ju\u017c u\u017cywany dla typu podmiotu: Siedziba podmiotu trzeciego, nazwy podmiotu xxxx i siedziby podmiotu xxxxx.\u201d To wcale nie znaczy, \u00a0\u017ce zduplikowany NIP na siedzibie wymienionej &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=1080\">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":[21,22],"tags":[215,217,216],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1080"}],"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=1080"}],"version-history":[{"count":3,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1080\/revisions"}],"predecessor-version":[{"id":1089,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1080\/revisions\/1089"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}