eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_BULK_PICK dependencies on MTL_ALLOCATIONS_GTMP

Line 876: from mtl_allocations_gtmp

872: select sum(transaction_quantity) transaction_quantity,
873: sum(primary_quantity) primary_quantity,
874: sum(secondary_quantity) secondary_quantity, --12747184
875: lot_number
876: from mtl_allocations_gtmp
877: where transaction_temp_id = p_temp_id
878: group by lot_number;
879:
880: BEGIN

Line 1306: FROM mtl_allocations_gtmp mag

1302: SELECT mag.transaction_temp_id,
1303: mag.primary_quantity,
1304: mag.transaction_quantity,
1305: mag.secondary_quantity --bug 8197506
1306: FROM mtl_allocations_gtmp mag
1307: WHERE lot_number = p_lot_number
1308: ORDER BY search_sequence;
1309:
1310:

Line 1317: from mtl_allocations_gtmp

1313: SELECT sum(transaction_quantity) transaction_quantity,
1314: sum(primary_quantity) primary_quantity,
1315: sum(secondary_quantity) secondary_quantity , --12747184
1316: transaction_temp_id
1317: from mtl_allocations_gtmp
1318: group by transaction_temp_id;
1319:
1320: -- Start changes for 14699845 (Flexible Lot Allocation)
1321: CURSOR c_child_mmtts(p_tran_id NUMBER)

Line 1347: FROM mtl_material_transactions_temp mmtt , mtl_allocations_gtmp mag

1343: mmtt.parent_line_id,
1344: mag.lot_number,
1345: mag.secondary_quantity,
1346: mmtt.inventory_item_id
1347: FROM mtl_material_transactions_temp mmtt , mtl_allocations_gtmp mag
1348: WHERE mmtt.transaction_temp_id = mag.transaction_temp_id
1349: ORDER BY mag.transaction_quantity, mag.primary_quantity desc;
1350:
1351: CURSOR c_child_lot_allocation_exists

Line 1475: delete mtl_allocations_gtmp;

1471: END IF;
1472:
1473: -- make sure the global temp table is emplty
1474: IF (l_debug = 1) THEN mydebug('deleting the global temp table ',l_api_name); END IF;
1475: delete mtl_allocations_gtmp;
1476:
1477: -- populate the temp table mtl_allocations_gtmp
1478: if (p_lot_controlled = 'Y' ) THEN -- lot controlled
1479: IF (l_debug = 1) THEN

Line 1477: -- populate the temp table mtl_allocations_gtmp

1473: -- make sure the global temp table is emplty
1474: IF (l_debug = 1) THEN mydebug('deleting the global temp table ',l_api_name); END IF;
1475: delete mtl_allocations_gtmp;
1476:
1477: -- populate the temp table mtl_allocations_gtmp
1478: if (p_lot_controlled = 'Y' ) THEN -- lot controlled
1479: IF (l_debug = 1) THEN
1480: mydebug('inserting the records to the tmp table',l_api_name);
1481: END IF;

Line 1491: INTO mtl_allocations_gtmp

1487: FOR c_parent_lines_rec IN c_parent_mmtt_shorpick_lots
1488: LOOP
1489: l_search_sequence := l_search_sequence +1;
1490: INSERT
1491: INTO mtl_allocations_gtmp
1492: (
1493: TRANSACTION_TEMP_ID ,
1494: TRANSFER_LPN_ID ,
1495: LOT_NUMBER ,

Line 1524: INTO mtl_allocations_gtmp

1520: FOR c_parent_lines_rec IN c_parent_mmtt_lines_for_lots
1521: LOOP
1522: l_search_sequence := l_search_sequence +1;
1523: INSERT
1524: INTO mtl_allocations_gtmp
1525: (
1526: TRANSACTION_TEMP_ID ,
1527: TRANSFER_LPN_ID ,
1528: LOT_NUMBER ,

Line 1639: FROM mtl_allocations_gtmp

1635: -- first find out if the mmtt line for this parent line has been created or not, for multiple lots
1636: BEGIN
1637: SELECT child_transaction_temp_id
1638: INTO l_child_txn_temp_id
1639: FROM mtl_allocations_gtmp
1640: WHERE transaction_temp_id = c_lot_parents_rec.transaction_temp_id
1641: AND child_transaction_temp_id IS NOT NULL
1642: AND rownum = 1;
1643:

Line 1695: UPDATE mtl_allocations_gtmp

1691: l_child_txn_temp_id := l_new_temp_id;
1692: IF (l_debug = 1) THEN
1693: mydebug('update the processed qty for the new child line',l_api_name);
1694: END IF;
1695: UPDATE mtl_allocations_gtmp
1696: SET child_transaction_temp_id = l_new_temp_id
1697: WHERE transaction_temp_id = c_lot_parents_rec.transaction_temp_id;
1698:
1699: l_link_mtlt_needed := 'Y';

Line 1745: UPDATE mtl_allocations_gtmp

1741: END IF;
1742: mydebug('left sec lot qty to be processed '
1743: ||l_child_lot_sec_txn_qty,l_api_name); --bug 8197506
1744: -- update the quantity for the parent line in the gtmp
1745: UPDATE mtl_allocations_gtmp
1746: SET primary_quantity = primary_quantity -l_process_qty, -- only primary UOM will be used
1747: secondary_quantity = DECODE(secondary_quantity,NULL,NULL,secondary_quantity-l_process_sec_qty) --bug 8197506
1748: WHERE transaction_temp_id = c_lot_parents_rec.transaction_temp_id
1749: AND lot_number = c_child_lots_rec.lot_number;

Line 1755: DELETE mtl_allocations_gtmp

1751: IF (l_debug = 1) THEN
1752: mydebug('after updating the parent qty in the temp table.',l_api_name);
1753: END IF;
1754: -- delete the record if the qty has became 0
1755: DELETE mtl_allocations_gtmp
1756: WHERE transaction_temp_id = c_lot_parents_rec.transaction_temp_id
1757: AND primary_quantity = 0;
1758:
1759: IF (l_debug = 1 AND SQL%ROWCOUNT>0) THEN

Line 1776: UPDATE mtl_allocations_gtmp

1772: WHERE transaction_temp_id = c_mmtt_line.transaction_temp_id
1773: AND primary_quantity = 0;
1774:
1775: -- before process another mmtt line, the child transaction temp id should be nullified
1776: UPDATE mtl_allocations_gtmp
1777: SET child_transaction_temp_id = NULL;
1778:
1779: END LOOP; -- for mmtt
1780: IF c_child_mmtt_lines%ISOPEN THEN

Line 1863: DELETE FROM mtl_allocations_gtmp

1859: IF l_debug = 1 THEN
1860: mydebug('Since the full Child is consumed, delete from the GTEMP ' , l_api_name);
1861: END IF;
1862: -- Delete from mag
1863: DELETE FROM mtl_allocations_gtmp
1864: WHERE transaction_temp_id = rec_parent_mmtt_line.transaction_temp_id
1865: AND lot_number = rec_parent_mmtt_line.lot_number;
1866:
1867: EXIT;

Line 1907: UPDATE mtl_allocations_gtmp

1903: IF l_debug = 1 THEN
1904: mydebug('Update the GTMP TABLE, decrement with qty ' ||rec_child_mmtts.transaction_quantity, l_api_name);
1905: END IF;
1906:
1907: UPDATE mtl_allocations_gtmp
1908: SET transaction_quantity = transaction_quantity - rec_child_mmtts.transaction_quantity,
1909: primary_quantity = primary_quantity - rec_child_mmtts.primary_quantity,
1910: secondary_quantity = secondary_quantity - rec_child_mmtts.secondary_transaction_quantity
1911: WHERE transaction_temp_id = rec_parent_mmtt_line.transaction_temp_id

Line 1999: UPDATE mtl_allocations_gtmp

1995: mydebug('Update the GTMP TABLE, decrement with qty ' ||l_process_qty, l_api_name);
1996: mydebug('l_progress '|| l_progress,l_api_name);
1997: END IF;
1998:
1999: UPDATE mtl_allocations_gtmp
2000: SET transaction_quantity = transaction_quantity - l_process_qty,
2001: primary_quantity = primary_quantity - l_primary_qty,
2002: secondary_quantity = secondary_quantity - l_process_sec_qty
2003: WHERE transaction_temp_id = rec_parent_mmtt_line.transaction_temp_id

Line 2008: DELETE FROM mtl_allocations_gtmp

2004: AND lot_number = rec_parent_mmtt_line.lot_number;
2005:
2006: l_progress := 3.7;
2007:
2008: DELETE FROM mtl_allocations_gtmp
2009: WHERE transaction_quantity = 0
2010: AND transaction_temp_id = rec_parent_mmtt_line.transaction_temp_id
2011: AND lot_number = rec_parent_mmtt_line.lot_number;
2012: