27:
28: SELECT msub.asset_inventory,
29: msi.inventory_asset_flag
30: FROM mtl_secondary_inventories msub,
31: mtl_system_items msi
32: WHERE msub.secondary_inventory_name = x_subinventory
33: AND msub.organization_id = x_org_id
34: AND msi.inventory_item_id = x_item_id
35: AND msi.organization_id = x_org_id;