APPS.INV_LOT_ATTRIBUTE_SYNC_PVT dependencies on MTL_LOT_NUMBERS

Line 238: update mtl_lot_numbers

234: l_dest_lot_number;
235: EXIT WHEN c_dest_lotatt%NOTFOUND;
236: --update MLN against MTL_LOTATT_SYNC_REPORT_TMP from source to dest
237: IF(nvl(p_syndff_flag,2) = 2) THEN --syn lot dff attributes when the flag enabled
238: update mtl_lot_numbers
239: set grade_code = l_grade_code,
240: origination_date = l_orig_date,
241: expiration_date = l_exp_date,
242: maturity_date = l_mat_date,

Line 251: update mtl_lot_numbers

247: where organization_id = l_dest_org_id
248: and inventory_item_id = l_dest_item_id
249: and lot_number = l_dest_lot_number;
250: ELSE
251: update mtl_lot_numbers
252: set grade_code = l_grade_code,
253: origination_date = l_orig_date,
254: expiration_date = l_exp_date,
255: maturity_date = l_mat_date,