862: /*=============================
863: Insert to Temp Table.
864: =============================*/
865:
866: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
867: transaction_header_id,
868: transaction_temp_id,
869: transaction_type_id,
870: transaction_action_id,
1491: ============================================*/
1492:
1493: CURSOR c_check_mmtt IS
1494: SELECT 1
1495: FROM mtl_material_transactions_temp
1496: WHERE lot_number = p_lot_number
1497: AND inventory_item_id = p_inventory_item_id
1498: AND organization_id = p_organization_id;
1499:
1498: AND organization_id = p_organization_id;
1499:
1500: CURSOR c_check_mmtt_head IS
1501: SELECT 1
1502: FROM mtl_material_transactions_temp
1503: WHERE lot_number = p_lot_number
1504: AND inventory_item_id = p_inventory_item_id
1505: AND organization_id = p_organization_id
1506: AND transaction_header_id <> p_header_id