Hub integration testreport

➜ Back to Library
Description
select
msib.*
from
mtl_system_items_b msib
where
1=1
Parameter NameSQL textValidation
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 Manufacturing Variance EC: INV Item Upload INV Item Upload WSH Pick Slip CAC Inventory and Intransit Value (Period-End) - Discrete/OPM PURE Lotwise Aging CAC Calculate Average Item Costs CAC ICP PII Inventory Pending Cost Adjustment CAC Intercompany SO Price List vs. Item Cost Comparison CAC Inventory Pending Cost Adjustment
Blitz Report™