1 Reply Latest reply on Aug 12, 2015 1:53 PM by thatJeffSmith-Oracle

    SQL Developer on MAC OSx Yosemite 10.10.4 and on Windows 7. Different result.

    meck50

      What reasons could there be for two executions of the same script in SQL Developer  from a MAC and from a Windows client  to produce different result? Mac yields null and windows hundreds of lines. Same version 4.1.1.19.  Script contains joins. Same external Oracle DB holds the data.

      Could it be encoding in strings?

       

      Script:

       

      select   jgzz_fiscal_code, party_name, pris, tlf    ,start_date ,listname    ,override_price

      from           

      (select distinct        

      qll.attribute1 asoc,          

      qll.operand pris     ,qlh.name listname    

      from           

      apps.QP_LIST_LINES qll, apps.QP_LIST_HEADERS qlh,           

      apps.mtl_system_items msi,           

      apps.qp_pricing_attributes qpa          

      where           

      qll.LIST_HEADER_ID=qlh.LIST_HEADER_ID           

      --and qlh.name like 'Telia Sverige Standardprislista%'         

      and( qll.END_DATE_ACTIVE is null       or     qll.END_DATE_ACTIVE >sysdate)

      and qll.start_DATE_ACTIVE < sysdate

      and qll.attribute1  not like '-%'           

      and qlh.end_date_active is null           

      and msi.segment1 ='TLF'           

      and msi.INVENTORY_ITEM_ID = qpa.product_attr_value           

      and qpa.list_line_id = qll.list_line_id           

      and  qpa.PRODUCT_ATTRIBUTE_context = 'ITEM'           

      ) tlfasoc          

        join           

      (          

      select jgzz_fiscal_code,party_name ,ASOC_ID, tlf,       start_date      ,override_price

      from          

      (select jgzz_fiscal_code,party_name ,xiri.ASOC_ID,cii.external_reference tlf_ref    , override_price     

      from ar.hz_parties hp, aPps.hz_cust_accounts hca,xxib.xxib_i10_recurring_items xiri, apps.csi_item_instances cii,           

      apps.mtl_system_items msi           

      where  msi.segment1 ='TLF'           

      and hp.person_identifier is null     

      and cii.inventory_item_id=msi.inventory_item_id           

      and cii.active_end_date is null           

      and cii.active_start_date >to_date ('20150630','YYYYMMDD')       

      and hp.party_id= cii.owner_party_id       

              

      --and override_price is null           

      and xiri.ITEM_INSTANCE_ID=cii.INSTANCE_ID           

      and xiri.CUST_ACCOUNT_ID=hca.CUST_ACCOUNT_ID           

      and xiri.INTVL_START_DATE < sysdate           

      and (xiri.INTVL_END_DATE is null or xiri.INTVL_END_DATE > sysdate)           

      and hca.ACCOUNT_TERMINATION_DATE is null   

      --and rownum <10

      ) tlf_charges           

      inner join            

      (select   tlf,  start_date   

        

      from        

      (select  external_reference tlf, cii.active_start_date   start_date   

      from  

      apps.mtl_system_items msi,          

      apps.csi_item_instances cii          

      where          

      msi.segment1 = 'TLF ANLÄGGNING'          

      and cii.inventory_item_id= msi.inventory_item_id          

      and cii.attribute6 is null        

      and  cii.active_end_date is  null

      and cii.active_start_date > to_date ('20150630','YYYYMMDD')

      --and rownum <10

      ) anls  

      inner join  

      (select chrgb_num from xxib.XXIB_I10_CHARGEABLE_NUMBER where CH_NUM_END_DATE is null) crg  

      on anls.tlf=crg. chrgb_num  

      ) tlfs          

      on tlfs.tlf =tlf_charges.tlf_ref          

      )nonbundle_tlfs           

      on tlfasoc.asoc  = nonbundle_tlfs.ASOC_ID;