1 Query and 2 different results
Hello everyone,
I found some new feature/ BUG for version 11.2.0.2.0 single instance and also RAC .
My query:
SELECT bp.hbp_name_tx ,bp.hbp_price_total_nr, bp.hbp_price_base_nr, bp.hbp_price_tax_nr, bp.hbp_id
FROM HSI_VES.hsi_akce a, hsi_ves.ves_pozadavek_zpoplatneni_v pz,
HSI_CMP.hsi_billing_price bp
WHERE
a.vea_id=(select rlr_ref_object_id from HSI_RL.rl_request r where r.rlr_ident_tx='1114000173')
AND pz.vea_vea_id = a.vea_id
AND bp.hbp_name_tx = 'DGN'
AND bp.vat_vat_id = a.vat_vat_id