[Home] [Help]
1250: X_mrp_plan = 9 ) then
1251: -- If this returns a row, the sub is nettable or null
1252: select count(1)
1253: into nettable_sub
1254: from mtl_secondary_inventories
1255: where secondary_inventory_name=nvl(X_source_sub, secondary_inventory_name)
1256: and availability_type = 1
1257: and rownum = 1;
1258: end if;