48: ms.receipt_date,
49: ms.supply_type_code,
50: ms.supply_source_id,
51: ms.rowid row_id
52: from mtl_supply ms
53: where ms.change_flag = 'Y'
54: FOR UPDATE ;
55:
56: supply_rec supply_cursor%rowtype;
98: /*
99: ** Remove unnecessary supply records
100: */
101:
102: delete from mtl_supply
103: where rowid = supply_rec.row_id;
104:
105: else
106:
168:
169:
170: begin
171:
172: update mtl_supply
173: set to_org_primary_quantity = primary_qty,
174: to_org_primary_uom = primary_uom,
175: change_flag = null,
176: expected_delivery_date =