APPS.WMS_BULK_PICK dependencies on MTL_ALLOCATIONS_GTMP

Line 836: from mtl_allocations_gtmp

832:
833: CURSOR over_picked_lots(p_temp_id NUMBER) IS
834: select sum(transaction_quantity) transaction_quantity,
835: sum(primary_quantity) primary_quantity, lot_number
836: from mtl_allocations_gtmp
837: where transaction_temp_id = p_temp_id
838: group by lot_number;
839:
840: BEGIN

Line 1066: FROM mtl_allocations_gtmp mag

1062: CURSOR c_lot_parents(p_lot_number VARCHAR2) IS
1063: SELECT mag.transaction_temp_id,
1064: mag.primary_quantity,
1065: mag.transaction_quantity
1066: FROM mtl_allocations_gtmp mag
1067: WHERE lot_number = p_lot_number
1068: ORDER BY search_sequence;
1069:
1070:

Line 1075: from mtl_allocations_gtmp

1071:
1072: CURSOR over_picked_lines IS
1073: SELECT sum(transaction_quantity) transaction_quantity,
1074: sum(primary_quantity) primary_quantity, transaction_temp_id
1075: from mtl_allocations_gtmp
1076: group by transaction_temp_id;
1077:
1078:
1079: l_parent_txn_qty NUMBER;

Line 1174: delete mtl_allocations_gtmp;

1170: END IF;
1171:
1172: -- make sure the global temp table is emplty
1173: IF (l_debug = 1) THEN mydebug('deleting the global temp table ',l_api_name); END IF;
1174: delete mtl_allocations_gtmp;
1175:
1176: -- populate the temp table mtl_allocations_gtmp
1177: if (p_lot_controlled = 'Y' ) THEN -- lot controlled
1178:

Line 1176: -- populate the temp table mtl_allocations_gtmp

1172: -- make sure the global temp table is emplty
1173: IF (l_debug = 1) THEN mydebug('deleting the global temp table ',l_api_name); END IF;
1174: delete mtl_allocations_gtmp;
1175:
1176: -- populate the temp table mtl_allocations_gtmp
1177: if (p_lot_controlled = 'Y' ) THEN -- lot controlled
1178:
1179: IF (l_debug = 1) THEN mydebug('inserting the records to the tmp table',l_api_name); END IF;
1180:

Line 1190: insert into mtl_allocations_gtmp

1186:
1187: IF (l_debug = 1) THEN mydebug('Inserting from c_parent_mmtt_shorpick_lots v1',l_api_name); END IF;
1188: FOR c_parent_lines_rec IN c_parent_mmtt_shorpick_lots LOOP
1189: l_search_sequence := l_search_sequence +1;
1190: insert into mtl_allocations_gtmp
1191: ( TRANSACTION_TEMP_ID
1192: , TRANSFER_LPN_ID
1193: , LOT_NUMBER
1194: , TRANSACTION_QUANTITY

Line 1216: insert into mtl_allocations_gtmp

1212: END LOOP;
1213: ELSE
1214: FOR c_parent_lines_rec IN c_parent_mmtt_lines_for_lots LOOP
1215: l_search_sequence := l_search_sequence +1;
1216: insert into mtl_allocations_gtmp
1217: ( TRANSACTION_TEMP_ID
1218: , TRANSFER_LPN_ID
1219: , LOT_NUMBER
1220: , TRANSACTION_QUANTITY

Line 1285: from mtl_allocations_gtmp

1281: -- first find out if the mmtt line for this parent line has been created or not, for multiple lots
1282: BEGIN
1283: select child_transaction_temp_id
1284: into l_child_txn_temp_id
1285: from mtl_allocations_gtmp
1286: where transaction_temp_id = c_lot_parents_rec.transaction_temp_id
1287: and child_transaction_temp_id is not null
1288: and rownum = 1;
1289:

Line 1329: update mtl_allocations_gtmp

1325:
1326: l_child_txn_temp_id := l_new_temp_id;
1327: IF (l_debug = 1) THEN mydebug('update the processed qty for the new child line',l_api_name);
1328: END IF;
1329: update mtl_allocations_gtmp
1330: set child_transaction_temp_id = l_new_temp_id
1331: where transaction_temp_id = c_lot_parents_rec.transaction_temp_id;
1332:
1333: l_link_mtlt_needed := 'Y';

Line 1372: update mtl_allocations_gtmp

1368: -- update the processed lot quantity
1369: l_child_lot_txn_qty := l_child_lot_txn_qty-l_process_qty;
1370: IF (l_debug = 1) THEN mydebug('left lot qty to be processed '||l_child_lot_txn_qty,l_api_name); END IF;
1371: -- update the quantity for the parent line in the gtmp
1372: update mtl_allocations_gtmp
1373: set primary_quantity = primary_quantity-l_process_qty -- only primary UOM will be used
1374: where transaction_temp_id = c_lot_parents_rec.transaction_temp_id
1375: and lot_number = c_child_lots_rec.lot_number;
1376: IF (l_debug = 1) THEN mydebug('after updating the parent qty in the temp table.',l_api_name); END IF;

Line 1379: delete mtl_allocations_gtmp

1375: and lot_number = c_child_lots_rec.lot_number;
1376: IF (l_debug = 1) THEN mydebug('after updating the parent qty in the temp table.',l_api_name); END IF;
1377:
1378: -- delete the record if the qty has became 0
1379: delete mtl_allocations_gtmp
1380: where transaction_temp_id = c_lot_parents_rec.transaction_temp_id
1381: and primary_quantity = 0;
1382: IF (l_debug = 1 and SQL%ROWCOUNT>0) THEN
1383: mydebug('records deteted for qty 0 in the temp table '||SQL%ROWCOUNT,l_api_name);

Line 1398: update mtl_allocations_gtmp

1394: WHERE transaction_temp_id = c_mmtt_line.transaction_temp_id
1395: AND primary_quantity = 0;
1396:
1397: -- before process another mmtt line, the child transaction temp id should be nullified
1398: update mtl_allocations_gtmp
1399: set child_transaction_temp_id = null;
1400: END LOOP; -- for mmtt
1401:
1402: IF c_child_mmtt_lines%ISOPEN THEN