Hub integration testreport

➜ Back to Library
Description
Run Hub integration testreport and other Oracle EBS reports with Blitz Report™ on our demo environment
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
)
 Char
Download
Related Blitz Reports
CAC WIP Material Usage with Configuration and Lot Variances CAC Manufacturing Variance Detail CAC Manufacturing Variance Summary WSH Pick Slip CAC Calculate Average Item Costs CAC ICP PII Inventory Pending Cost Adjustment CAC Calculate ICP PII Item Costs by Where Used CAC Inventory Pending Cost Adjustment CAC Intercompany SO Price List vs. Item Cost Comparison CAC Calculate ICP PII Item Costs
Blitz Report™

Blitz Report™ provides multiple benefits: