APPS.INVPPROC dependencies on MTL_SERIAL_TAGGING_ASSIGNMENTS

Line 149: MTL_SYSTEM_ITEMS_INTERFACE I , MTL_SERIAL_TAGGING_ASSIGNMENTS S

145:
146: CURSOR update_inv_item_id IS
147: SELECT I.inventory_item_id,I.organization_id,I.transaction_id
148: FROM
149: MTL_SYSTEM_ITEMS_INTERFACE I , MTL_SERIAL_TAGGING_ASSIGNMENTS S
150: WHERE
151: I.process_flag = l_process_flag_4
152: AND I.set_process_id = xset_id
153: AND I.transaction_type = l_transaction_type

Line 295: UPDATE mtl_serial_tagging_assignments

291: -- in multi item template case.
292:
293: FOR I IN update_inv_item_id LOOP
294:
295: UPDATE mtl_serial_tagging_assignments
296: SET inventory_item_id =I.inventory_item_id
297: WHERE inventory_item_id <0
298: AND inventory_item_id=(-1 * I.transaction_id)
299: AND organization_id=i.organization_id;