51: SELECT TRANSACTION_TYPE_ID,
52: TRANSACTION_SOURCE_TYPE_ID
53: INTO L_TRANSACTION_TYPE_ID,
54: L_TRANSACTION_SOURCE_TYPE_ID
55: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
56: WHERE TRANSACTION_TEMP_ID = P_TEMP_ID;
57:
58: IF L_TRANSACTION_TYPE_ID = 52 THEN
59: -- Picking for sales order
268: l_inventory_item_id,
269: l_subinventory_code,
270: l_locator_id,
271: l_organization_id
272: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
273: MTL_SYSTEM_ITEMS_B msi,
274: mtl_secondary_inventories sub -- bug 2675498
275: WHERE MMTT.TRANSACTION_TEMP_ID = P_TRANSACTION_TEMP_ID
276: AND MMTT.ORGANIZATION_ID = MSI.ORGANIZATION_ID
345: BEGIN
346:
347: SELECT 1
348: INTO L_IS_BULK_PICK
349: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
350: WHERE PARENT_LINE_ID = P_TRANSACTION_TEMP_ID
351: AND ROWNUM < 2;
352:
353: IF (l_debug = 1) THEN
397: L_LOCATOR_ID,
398: L_TRANSFER_SUBINVENTORY
399:
400:
401: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
402: ,MTL_SYSTEM_ITEMS_B MSI
403: ,MTL_TRANSACTION_LOTS_TEMP MTLT
404: WHERE MMTT.ORGANIZATION_ID = MSI.ORGANIZATION_ID
405: AND MMTT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
677: mydebug('in procedure load_task');
678: END IF;
679: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
680:
681: UPDATE mtl_material_transactions_temp
682: SET transfer_lpn_id = l_lpn_id,
683: last_update_date = SYSDATE,
684: last_updated_by = p_user_id
685: WHERE transaction_temp_id = l_temp_id;