8098: END IF;
8099:
8100: SELECT NVL(MAX(secondary_inventory_name), 'notfound')
8101: INTO x_subinventory
8102: FROM mtl_secondary_inventories msub,
8103: mtl_system_items msi
8104: WHERE msub.secondary_inventory_name = x_cascaded_table(n).subinventory
8105: AND msub.organization_id = x_cascaded_table(n).to_organization_id
8106: AND x_cascaded_table(n).transaction_date < NVL(msub.disable_date, x_cascaded_table(n).transaction_date + 1)