Hub integration testreport

Description
Columns: Inventory Item Id, Organization Id, Last Update Date, Last Updated By, Creation Date, Created By, Last Update Login, Summary Flag, Enabled Flag, Start Date Active ...
select
msib.*
from
mtl_system_items_b msib
where
1=1
Parameter Name SQL text Validation
organization_id|inventory_item_id
(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
)