ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A1AA864253628FF4E053B46B63581541Y select msib.* from mtl_system_items_b msib where 1=1 US Hub integration testreport 1=1 1 10 1=1 (msib.organization_id,msib.inventory_item_id) in ( select distinct dbms_lob.substr(xrrpv.value,instr(xrrpv.value,'|')-1) organization_id, dbms_lob.substr(xrrpv.value,20,instr(xrrpv.value,'|')+1) inventory_item_id from xxen_report_parameters_vl xrpv, xxen_report_run_param_values xrrpv where xrpv.parameter_name='organization_id|inventory_item_id' and xrpv.parameter_id=xrrpv.parameter_id and xrrpv.run_id=:run_id ) Char US organization_id|inventory_item_id