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