Inventory Listing

Description

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select mp.*, msib.*
from mtl_system_items_b msib, mtl_parameters mp
where 1=1
and mp.organization_id=msib.organization_id
Parameter Name SQL text Validation
Organization Code
mp.organization_code = :p_org_code
LOV
Last Update within Days
msib.last_update_date>sysdate-:days
Number