XML data file data laod to oracle tables -
<integration-outbound:integrationentity xmlns:integration-outbound="http://www.zycus.com/integration/schemas/integrationoutbound" xmlns:xsi="http://www.w3.org/2001/`enter code here`xmlschema-instance"> <integrationentityheader> <integrationtrackingnumber>146#cd7d54cf-def0-411c-8de3-3c7a4920fa0e#1c65e475-fde1-41e0-bae5-df947cf54d94#1504705293118</integrationtrackingnumber> <referencecodeforentity>280</referencecodeforentity> <additionalinfo /> <source>sim</source> <entity>supplier</entity> <action>create</action> <timestamputc>20170906t134156</timestamputc> <zdocbaseversion>1.0</zdocbaseversion> <zdoccustomversion>0</zdoccustomversion> </integrationentityheader> <integrationentitydetails> <supplier> <controlblock> <dataprocessinginfo> <key>mode</key> <value>create</value> </dataprocessinginfo> </controlblock> <id>2440407</id> <facilitycode>0001</facilitycode> <systemcode>1</systemcode> <suppliertype>operational</suppliertype> <status>active</status> <companydetails> <displaygsid>280</displaygsid> <legalcompanyname>auckland clinical studies ltd</legalcompanyname> <taxidformat>othr</taxidformat> <taxid>094-542-802</taxid> <companytypefix>supplier</companytypefix> </companydetails> <companyreferences /> <corporatefields /> <companydetailssupportingdoc /> <alllocations> <location> <addressinternalid>1658368</addressinternalid> <isdelete>false</isdelete> <internalsupplierid>2440407</internalsupplierid> <acctgrpid>part</acctgrpid> <address1>acs house 3 ferncroft street grafton</address1> <address2>auckland</address2> <pobox>8963</pobox> <country>nzl</country> <state>nz-auk</state> <city>auckland</city> <zip>1010</zip> <phone>64 9 373 3474</phone> </location> </alllocations> <contactdetails> <contactdetail> <contactinternalid>1290350</contactinternalid> <isdelete>false</isdelete> <addressinternalid>1658368</addressinternalid> <contacttype>ra</contacttype> <firstname>lynne</firstname> <lastname>jacobsen</lastname> <title>accountant</title> <email>lynne.jacobsen@clinicalstudies.co.nz</email> <phoneno>64-9-93733479</phoneno> <timezone>africa/abidjan</timezone> <currency>usd</currency> </contactdetail> </contactdetails> <mylocation> <addresses> <mylocationsinternalid>1658368</mylocationsinternalid> <isdelete>false</isdelete> <addressinternalid>1658368</addressinternalid> <usedat>n</usedat> </addresses> </mylocation> <forms> <form> <id>bankdetails_12</id> <records> <record> <internalid>12</internalid> <isdelete>false</isdelete> <fields> <field> <id>account_number_12345</id> <value>02-0800-0469974-00</value> </field> <field> <id>country_123123</id> <value>nzl</value> </field> <field> <id>remitaddress_12345</id> <value>1658368</value> </field> <field> <id>branchname_123</id> <value>auckland</value> </field> <field> <id>abasortcode_12</id> <value>0100</value> </field> <field> <id>pk_bankdetails_1212</id> <value>12</value> </field> <field> <id>swift_code_12345</id> <value>bknznz22</value> </field> <field> <id>accountname_12345</id> <value>auckland clinical studies ltd</value> </field> <field> <id>accounttype1122</id> <value>1</value> </field> <field> <id>bank_name_123123</id> <value>bank of new zealand</value> </field> </fields> </record> </records> </form> <form> <id>qulrepo</id> <records> <record> <isdelete>false</isdelete> <fields> <field> <id>qacc</id> <value>-1</value> </field> </fields> </record> </records> </form> <form> <id>compdetail</id> <records> <record> <isdelete>false</isdelete> <fields> <field> <id>ddr123</id> <value>-1</value> </field> <field> <id>abac123</id> <value>-1</value> </field> </fields> </record> </records> </form> <form> <id>site_123</id> <records> <record> <internalid>16</internalid> <isdelete>false</isdelete> <fields> <field> <id>abasort_12345</id> <value>12</value> </field> <field> <id>foradd_12345</id> <value>1658368</value> </field> <field> <id>operatingunit_1234</id> <value>207</value> </field> <field> <id>paymentmethod_1234</id> <value>wire</value> </field> <field> <id>pk_site_123</id> <value>16</value> </field> <field> <id>site_12345</id> <value>wire-usd</value> </field> <field> <id>taxreportable_1234</id> <value>n</value> </field> </fields> </record> <record> <internalid>17</internalid> <isdelete>false</isdelete> <fields> <field> <id>abasort_12345</id> <value>12</value> </field> <field> <id>foradd_12345</id> <value>1658368</value> </field> <field> <id>operatingunit_1234</id> <value>893</value> </field> <field> <id>paymentmethod_1234</id> <value>wire</value> </field> <field> <id>pk_site_123</id> <value>17</value> </field> <field> <id>site_12345</id> <value>rhs-wire usd</value> </field> <field> <id>taxreportable_1234</id> <value>n</value> </field> </fields> </record> </records> </form> <form> <id>sourcingdet</id> <records> <record> <internalid>3</internalid> <isdelete>false</isdelete> <fields> <field> <id>fob22123</id> <value>destination</value> </field> <field> <id>invcurr2345</id> <value>usd</value> </field> <field> <id>pk_sourcingdet</id> <value>3</value> </field> <field> <id>opunit123123</id> <value>207</value> </field> <field> <id>paytermssss</id> <value>10001</value> </field> </fields> </record> </records> </form> <form> <id>basicsupplierinformation123</id> <records> <record> <isdelete>false</isdelete> <fields> <field> <id>renovations_123</id> <value>-1</value> </field> <field> <id>assets_123</id> <value>-1</value> </field> <field> <id>systems_3234</id> <value>-1</value> </field> <field> <id>anti_231</id> <value>-1</value> </field> <field> <id>supponsilte_123</id> <value>-1</value> </field> <field> <id>location_321</id> <value>-1</value> </field> <field> <id>regbeh_123</id> <value>-1</value> </field> <field> <id>systems_123</id> <value>-1</value> </field> </fields> </record> </records> </form> <form> <id>taxdetails</id> <records> <record> <isdelete>false</isdelete> <fields> <field> <id>allow_with_tax</id> <value>-1</value> </field> </fields> </record> </records> </form> </forms> </supplier> </integrationentitydetails> </integration-outbound:integrationentity> the above query fetching data , in forms elements there many tag form , fields, field same name. want data form 4, form5, form7 elements. , field(id want come columns name , values row. above query fetching 41 rows, want 2 rows. please query.
Comments
Post a Comment