APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on MTL_TRANSACTION_LOTS_TEMP

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

5277: print_debug('Item is lot Controlled',l_module_name,9);
5278: END IF;
5279:
5280: --delete MTLT where transaction_temp_id = l_inbound_doc_parent_rec.transaction_temp_id
5281: DELETE FROM mtl_transaction_lots_temp WHERE transaction_temp_id = l_inbound_doc_parent_rec.transaction_temp_id;
5282:
5283: --create PL/SQL records for MTLT based on MTLT linked to l_inbound_doc_child_rec.transaction_temp_id
5284:
5285:

Line 5289: INSERT INTO mtl_transaction_lots_temp

5285:
5286:
5287: l_progress := 70;
5288:
5289: INSERT INTO mtl_transaction_lots_temp
5290: (
5291: transaction_temp_id
5292: , last_update_date
5293: , last_updated_by

Line 5452: FROM mtl_transaction_lots_temp

5448: , n_attribute9
5449: , n_attribute10
5450: , vendor_id
5451: , territory_code
5452: FROM mtl_transaction_lots_temp
5453: WHERE transaction_temp_id = l_inbound_doc_child_rec.transaction_temp_id;
5454:
5455: END IF;
5456:

Line 5547: INSERT INTO mtl_transaction_lots_temp

5543:
5544:
5545: l_progress := 70;
5546:
5547: INSERT INTO mtl_transaction_lots_temp
5548: (
5549: transaction_temp_id
5550: , last_update_date
5551: , last_updated_by

Line 5710: FROM mtl_transaction_lots_temp

5706: , n_attribute9
5707: , n_attribute10
5708: , vendor_id
5709: , territory_code
5710: FROM mtl_transaction_lots_temp
5711: WHERE transaction_temp_id = l_inbound_doc_child_split_rec.transaction_temp_id;
5712:
5713: END IF;
5714: