211: mon.TRANSFER_QTY,
212: mon.TRANSFER_UOM, /*ds change change end */
213: mon.REFRESH_ID,
214: mon.SR_INSTANCE_ID
215: from MSC_ST_OPERATION_NETWORKS mon,
216: MSC_ITEM_ID_LID t1 /* ds change change */
217: WHERE mon.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
218: AND mon.DELETED_FLAG = MSC_UTIL.SYS_NO
219: AND mon.FROM_ITEM_ID = t1.SR_INVENTORY_ITEM_ID(+) /* ds change change */
226: mon.TO_OP_SEQ_ID,
227: mon.DELETED_FLAG,
228: mon.REFRESH_ID,
229: mon.SR_INSTANCE_ID
230: FROM MSC_ST_OPERATION_NETWORKS mon
231: WHERE mon.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
232: and mon.DELETED_FLAG= MSC_UTIL.SYS_YES;
233:
234: c_count NUMBER:= 0;