APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 5402: DELETE FROM mtl_transaction_lots_temp WHERE transaction_temp_id = l_inbound_doc_parent_rec.transaction_temp_id;

5398: print_debug('Item is lot Controlled',l_module_name,9);
5399: END IF;
5400:
5401: --delete MTLT where transaction_temp_id = l_inbound_doc_parent_rec.transaction_temp_id
5402: DELETE FROM mtl_transaction_lots_temp WHERE transaction_temp_id = l_inbound_doc_parent_rec.transaction_temp_id;
5403:
5404: --create PL/SQL records for MTLT based on MTLT linked to l_inbound_doc_child_rec.transaction_temp_id
5405:
5406:

Line 5410: INSERT INTO mtl_transaction_lots_temp

5406:
5407:
5408: l_progress := 70;
5409:
5410: INSERT INTO mtl_transaction_lots_temp
5411: (
5412: transaction_temp_id
5413: , last_update_date
5414: , last_updated_by

Line 5573: FROM mtl_transaction_lots_temp

5569: , n_attribute9
5570: , n_attribute10
5571: , vendor_id
5572: , territory_code
5573: FROM mtl_transaction_lots_temp
5574: WHERE transaction_temp_id = l_inbound_doc_child_rec.transaction_temp_id;
5575:
5576: END IF;
5577:

Line 5672: INSERT INTO mtl_transaction_lots_temp

5668:
5669:
5670: l_progress := 70;
5671:
5672: INSERT INTO mtl_transaction_lots_temp
5673: (
5674: transaction_temp_id
5675: , last_update_date
5676: , last_updated_by

Line 5835: FROM mtl_transaction_lots_temp

5831: , n_attribute9
5832: , n_attribute10
5833: , vendor_id
5834: , territory_code
5835: FROM mtl_transaction_lots_temp
5836: WHERE transaction_temp_id = l_inbound_doc_child_split_rec.transaction_temp_id;
5837:
5838: END IF;
5839: