APPS.WMS_ITEM_LOAD dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1880: UPDATE mtl_material_transactions_temp

1876: -- Dummy MMTT records should have the wms_task_type set to 2 for
1877: -- putaway transactions. This is needed by the inventory TM so
1878: -- it can bypass the call to finalize_pick_confirm. We should call
1879: -- the ATF apis instead to update the move order lines.
1880: UPDATE mtl_material_transactions_temp
1881: SET wms_task_type = 2
1882: WHERE transaction_temp_id = l_txn_temp_id
1883: AND organization_id = p_organization_id;
1884: IF (l_debug = 1) THEN

Line 2115: FROM mtl_material_transactions_temp

2111: -- of type Container Split or Inventory sub transfer. Putaway
2112: -- suggestions if in inventory should be of type Move order sub transfers.
2113: CURSOR mmtt_suggestions_cursor IS
2114: SELECT transaction_temp_id
2115: FROM mtl_material_transactions_temp
2116: WHERE organization_id = p_organization_id
2117: AND lpn_id = p_lpn_id
2118: AND transaction_header_id <> p_txn_header_id
2119: AND NOT (transaction_source_type_id = 13 AND

Line 2130: FROM mtl_material_transactions_temp

2126: -- These records will be of type container split or inventory
2127: -- sub transfer.
2128: CURSOR mo_lines_cursor IS
2129: SELECT DISTINCT move_order_line_id
2130: FROM mtl_material_transactions_temp
2131: WHERE organization_id = p_organization_id
2132: AND transaction_header_id = p_txn_header_id
2133: AND (transaction_source_type_id = 13 AND
2134: transaction_type_id IN (89, 2) AND

Line 2180: FROM mtl_material_transactions_temp mmtt,

2176: mmtt.lpn_id,
2177: mmtt.transfer_lpn_id,
2178: mtlt.lot_number,
2179: mtlt.serial_transaction_temp_id
2180: FROM mtl_material_transactions_temp mmtt,
2181: mtl_transaction_lots_temp mtlt
2182: WHERE mmtt.organization_id = p_organization_id
2183: AND mmtt.transaction_header_id = p_txn_header_id
2184: AND (mmtt.transaction_source_type_id = 13 AND

Line 2982: DELETE FROM mtl_material_transactions_temp

2978:
2979: IF (l_debug = 1) THEN
2980: print_debug('Delete the dummy MMTT records: ' || l_mmtt_temp_id);
2981: END IF;
2982: DELETE FROM mtl_material_transactions_temp
2983: WHERE transaction_temp_id = l_mmtt_temp_id;
2984:
2985: IF (l_debug = 1) THEN
2986: print_debug('Finished deleting all dummy pack/unpack records');

Line 3155: UPDATE mtl_material_transactions_temp

3151: IF (l_debug = 1) THEN
3152: print_debug('Update the LPN ID/sub/loc on MMTT record');
3153: END IF;
3154: BEGIN
3155: UPDATE mtl_material_transactions_temp
3156: SET lpn_id = p_into_lpn_id
3157: , allocated_lpn_id = p_into_lpn_id
3158: , subinventory_code = Decode(p_lpn_context,
3159: WMS_CONTAINER_PUB.lpn_context_inv,

Line 3525: FROM mtl_material_transactions_temp mmtt,

3521: -- This cursor will get all of the MMTT suggestionss associated with the lpn_id passed.
3522: -- Cleanup should not be called if there are no WDT records.
3523: CURSOR mmtt_suggestions_cursor IS
3524: SELECT mmtt.transaction_temp_id
3525: FROM mtl_material_transactions_temp mmtt,
3526: mtl_txn_request_lines mtrl,
3527: wms_dispatched_tasks wdt
3528: WHERE mmtt.organization_id = p_organization_id
3529: AND mmtt.transaction_temp_id = wdt.transaction_temp_id