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_MATERIAL_TRANSACTIONS_TEMP

Line 151: INSERT INTO mtl_material_transactions_temp

147: 'p_new_child_temp_id'||p_new_child_temp_id ||g_newline||
148: 'p_split_sec_qty'||p_split_sec_qty ,l_api_name);
149: END IF;
150: -- 8197506
151: INSERT INTO mtl_material_transactions_temp
152: (
153: transaction_header_id
154: , transaction_temp_id
155: , source_code

Line 556: FROM mtl_material_transactions_temp

552: , parent_line_id
553: , serial_allocated_flag
554: , move_order_line_id
555: , l_g_task_loaded -- Bug# 4185621: loaded status
556: FROM mtl_material_transactions_temp
557: WHERE transaction_temp_id = p_child_temp_id);
558:
559: -- update the old line with remaining qty
560: update mtl_material_transactions_temp

Line 560: update mtl_material_transactions_temp

556: FROM mtl_material_transactions_temp
557: WHERE transaction_temp_id = p_child_temp_id);
558:
559: -- update the old line with remaining qty
560: update mtl_material_transactions_temp
561: set primary_quantity = primary_quantity-p_split_pri_qty, -- UOM
562: secondary_transaction_quantity = decode(secondary_transaction_quantity,NULL,NULL,secondary_transaction_quantity-p_split_sec_qty), --bug 8197506
563: transaction_quantity = transaction_quantity-p_split_pri_qty
564: where transaction_temp_id = p_child_temp_id;

Line 812: from mtl_material_transactions_temp

808:
809: -- get the information in parent
810: select transfer_lpn_id,nvl(lpn_id,content_lpn_id),subinventory_code,locator_id, transaction_uom
811: into l_transfer_lpn_id,l_lpn_id,l_parent_sub_code,l_parent_loc_id,l_parent_uom
812: from mtl_material_transactions_temp
813: where transaction_temp_id = p_parent_temp_id;
814:
815: IF p_child_temp_id is not null THEN
816: IF l_debug=1 THEN

Line 821: UPDATE mtl_material_transactions_temp mmtt

817: mydebug('update child line '||p_child_temp_id||' with parent info and new header id '||p_new_txn_hdr_id,l_api_name);
818: END IF;
819:
820: -- update child line with the correct parent info
821: UPDATE mtl_material_transactions_temp mmtt
822: SET mmtt.transaction_header_id = p_new_txn_hdr_id
823: , mmtt.transfer_lpn_id = l_transfer_lpn_id
824: , mmtt.lpn_id = l_lpn_id
825: , mmtt.parent_line_id = p_parent_temp_id

Line 840: UPDATE mtl_material_transactions_temp mmtt

836: -- update all child lines with the correct parent info
837: IF l_debug=1 THEN
838: mydebug('update all child lines with parent info and new header id '||p_new_txn_hdr_id,l_api_name);
839: END IF;
840: UPDATE mtl_material_transactions_temp mmtt
841: SET mmtt.transaction_header_id = p_new_txn_hdr_id
842: , mmtt.transfer_lpn_id = l_transfer_lpn_id
843: , mmtt.lpn_id = l_lpn_id
844: , mmtt.parent_line_id = p_parent_temp_id

Line 865: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

861: p_txn_qty NUMBER,
862: p_sec_qty NUMBER, --12747184
863: p_lot_controlled VARCHAR2
864: ) IS
865: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
866: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
867: l_new_temp_id NUMBER;
868: l_api_name VARCHAR2(30) := 'create_sub_transfer';
869: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 885: from mtl_material_transactions_temp

881: -- need to copy the child line since the child line contains the neccessary info
882: -- which the sub transfer needs
883: select *
884: into l_mmtt_rec
885: from mtl_material_transactions_temp
886: where transaction_temp_id <> p_from_temp_id
887: and parent_line_id = p_from_temp_id
888: and rownum <2;
889:

Line 1175: FROM mtl_material_transactions_temp mmtt

1171: , mmtt.transaction_uom
1172: , mmtt.transaction_quantity
1173: , mmtt.primary_quantity
1174: , mmtt.secondary_transaction_quantity --bug 8197506
1175: FROM mtl_material_transactions_temp mmtt
1176: WHERE mmtt.transaction_header_id = p_txn_hdr_id
1177: AND mmtt.organization_id = p_org_id
1178: AND mmtt.transaction_quantity > 0
1179: AND mmtt.parent_line_id = mmtt.transaction_temp_id -- make sure it is only parent lines

Line 1193: FROM mtl_material_transactions_temp mmtt

1189: , mmtt.transaction_uom
1190: , mmtt.transaction_quantity
1191: , mmtt.primary_quantity
1192: , mmtt.secondary_transaction_quantity --bug 8197506
1193: FROM mtl_material_transactions_temp mmtt
1194: WHERE mmtt.transaction_header_id = p_txn_hdr_id
1195: AND mmtt.organization_id = p_org_id
1196: AND mmtt.transaction_quantity > 0
1197: AND mmtt.parent_line_id <> p_temp_id

Line 1211: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt

1207: , mtlt.lot_number
1208: , mtlt.transaction_quantity lot_trx_qty
1209: , mtlt.primary_quantity lot_primary_qty
1210: , mtlt.secondary_quantity lot_sec_qty --bug 8197506
1211: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt
1212: WHERE mmtt.transaction_header_id = p_txn_hdr_id
1213: AND mmtt.organization_id = p_org_id
1214: AND mmtt.transaction_quantity > 0
1215: AND mmtt.parent_line_id = mmtt.transaction_temp_id

Line 1226: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt

1222: , mtlt.lot_number
1223: , mtlt.transaction_quantity lot_trx_qty
1224: , mtlt.primary_quantity lot_primary_qty
1225: , mtlt.secondary_quantity lot_sec_qty --bug 8197506
1226: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt
1227: WHERE mmtt.transaction_header_id = p_txn_hdr_id
1228: AND mmtt.organization_id = p_org_id
1229: AND mmtt.transaction_quantity > 0
1230: AND mmtt.parent_line_id <> p_temp_id

Line 1242: FROM mtl_material_transactions_temp mmtt

1238: , mmtt.transaction_uom
1239: , mmtt.transaction_quantity
1240: , mmtt.primary_quantity
1241: , mmtt.secondary_transaction_quantity --bug 8197506
1242: FROM mtl_material_transactions_temp mmtt
1243: WHERE mmtt.parent_line_id = p_temp_id
1244: AND mmtt.parent_line_id <> mmtt.transaction_temp_id -- exclude the parent line
1245: AND mmtt.organization_id = p_org_id
1246: ORDER BY mmtt.transaction_quantity DESC;

Line 1254: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,

1250: , mmtt.transaction_uom
1251: , mmtt.transaction_quantity
1252: , mmtt.primary_quantity
1253: , mmtt.secondary_transaction_quantity --bug 8197506
1254: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,
1255: wsh_delivery_details wdd,wsh_delivery_assignments_v wda
1256: WHERE mmtt.parent_line_id = p_temp_id
1257: AND mmtt.parent_line_id <> mmtt.transaction_temp_id -- exclude the parent line
1258: AND mmtt.organization_id = p_org_id

Line 1271: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,

1267: , mmtt.transaction_uom
1268: , mmtt.transaction_quantity
1269: , mmtt.primary_quantity
1270: , mmtt.secondary_transaction_quantity --bug 8197506
1271: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,
1272: wsh_delivery_details wdd,wsh_delivery_assignments_v wda,
1273: oe_order_lines_all ol,mtl_txn_request_headers moh
1274: WHERE mmtt.parent_line_id = p_temp_id
1275: AND mmtt.parent_line_id <> mmtt.transaction_temp_id -- exclude the parent line

Line 1329: FROM mtl_material_transactions_temp mmtt

1325: mmtt.primary_quantity,
1326: mmtt.parent_line_id,
1327: mmtt.inventory_item_id,
1328: mmtt.secondary_transaction_quantity
1329: FROM mtl_material_transactions_temp mmtt
1330: WHERE mmtt.transaction_temp_id <> mmtt.parent_line_id
1331: AND mmtt.parent_line_id = p_temp_id
1332: AND mmtt.transfer_lpn_id IS NULL
1333: ORDER BY mmtt.transaction_quantity;

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 1356: FROM mtl_material_transactions_temp mmtt

1352: IS
1353: SELECT 'Y'
1354: FROM mtl_transaction_lots_temp
1355: WHERE transaction_temp_id IN (SELECT mmtt.transaction_temp_id
1356: FROM mtl_material_transactions_temp mmtt
1357: WHERE mmtt.parent_line_id = p_temp_id
1358: AND mmtt.parent_line_id <> mmtt.transaction_temp_id);
1359: -- End changes for 14699845 (Flexible Lot Allocation)
1360:

Line 1426: FROM mtl_material_transactions_temp mmtt

1422: -- get the transaction action to be used later on
1423: BEGIN
1424: SELECT transaction_action_id
1425: INTO l_transaction_action_id
1426: FROM mtl_material_transactions_temp mmtt
1427: WHERE
1428: mmtt.transaction_temp_id = p_temp_id;
1429: EXCEPTION
1430: WHEN NO_DATA_FOUND THEN -- when the line merged from APL and old temp id is not there any more

Line 1433: FROM mtl_material_transactions_temp mmtt

1429: EXCEPTION
1430: WHEN NO_DATA_FOUND THEN -- when the line merged from APL and old temp id is not there any more
1431: SELECT transaction_action_id,transaction_temp_id
1432: INTO l_transaction_action_id,l_temp_id
1433: FROM mtl_material_transactions_temp mmtt
1434: WHERE transaction_header_id = p_txn_hdr_id
1435: and rownum<2;
1436: END;
1437:

Line 1464: UPDATE mtl_material_transactions_temp

1460: -- update all child line with the correct parent info
1461: update_child(null,l_temp_id,x_new_txn_hdr_id);
1462:
1463: --Bug# 4185621: update parent line posting flag back to 'N'
1464: UPDATE mtl_material_transactions_temp
1465: SET posting_flag = 'N'
1466: WHERE transaction_temp_id = l_temp_id
1467: AND parent_line_id = transaction_temp_id;
1468: -- Bug# 4185621: end change

Line 1512: UPDATE mtl_material_transactions_temp

1508: l_search_sequence ,
1509: c_parent_lines_rec.lot_sec_qty
1510: ); --bug 8197506
1511: --Bug# 4185621: update parent line posting flag back to 'N'
1512: UPDATE mtl_material_transactions_temp
1513: SET posting_flag = 'N'
1514: WHERE transaction_temp_id = c_parent_lines_rec.transaction_temp_id
1515: AND parent_line_id = transaction_temp_id;
1516:

Line 1546: UPDATE mtl_material_transactions_temp

1542: c_parent_lines_rec.lot_sec_qty --bug 8197506
1543: );
1544:
1545: --Bug# 4185621: update parent line posting flag back to 'N'
1546: UPDATE mtl_material_transactions_temp
1547: SET posting_flag = 'N'
1548: WHERE transaction_temp_id = c_parent_lines_rec.transaction_temp_id
1549: AND parent_line_id = transaction_temp_id;
1550:

Line 1650: UPDATE mtl_material_transactions_temp

1646: mydebug(' child line created before id:'
1647: || l_child_txn_temp_id,l_api_name);
1648: END IF;
1649: -- update the qty with the new process qty
1650: UPDATE mtl_material_transactions_temp
1651: SET primary_quantity = primary_quantity +l_process_qty ,
1652: secondary_transaction_quantity = DECODE(secondary_transaction_quantity,NULL,NULL,secondary_transaction_quantity + l_process_sec_qty), --bug 8197506
1653: transaction_quantity = transaction_quantity+l_process_qty ,
1654: posting_flag = 'Y' , -- Bug# 4185621: change child line posting flag back to 'Y'

Line 1659: UPDATE mtl_material_transactions_temp

1655: wms_task_status = l_g_task_loaded -- Bug# 4185621: make sure child line task status is loaded
1656: WHERE transaction_temp_id = l_child_txn_temp_id;
1657:
1658: /*Bug8460179-We need to deduct the qty form original child MMTTs*/
1659: UPDATE mtl_material_transactions_temp
1660: SET primary_quantity = primary_quantity - l_process_qty ,
1661: secondary_transaction_quantity = DECODE(secondary_transaction_quantity,NULL,NULL,secondary_transaction_quantity - l_process_sec_qty),
1662: transaction_quantity = transaction_quantity - l_process_qty
1663: WHERE transaction_temp_id = c_mmtt_line.transaction_temp_id;

Line 1771: FROM mtl_material_transactions_temp mmtt

1767: END LOOP; -- for parent lines, c_lot_parents_rec
1768: END LOOP; -- for mtlt,c_child_lots_rec
1769: -- delete the qty 0 mmtt due to the split
1770: DELETE
1771: FROM mtl_material_transactions_temp mmtt
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

Line 2092: UPDATE mtl_material_transactions_temp

2088: EXIT WHEN c_parent_mmtt_lines%NOTFOUND;
2089: END IF;
2090:
2091: --Bug# 4185621: update parent line posting flag back to 'N'
2092: UPDATE mtl_material_transactions_temp
2093: SET posting_flag = 'N'
2094: WHERE transaction_temp_id = l_parent_txn_temp_id
2095: AND parent_line_id = transaction_temp_id;
2096: -- Bug# 4185621: end change

Line 2139: UPDATE mtl_material_transactions_temp mmtt

2135: l_child_uom := l_parent_uom ; --bug#6848907.child qty is in parent uom now
2136: END IF;
2137:
2138: IF l_parent_txn_qty >= l_child_txn_qty THEN
2139: UPDATE mtl_material_transactions_temp mmtt
2140: SET mmtt.transaction_header_id = x_new_txn_hdr_id
2141: , mmtt.transfer_lpn_id = l_transfer_lpn_id
2142: , mmtt.lpn_id = l_lpn_id
2143: , mmtt.parent_line_id = l_parent_txn_temp_id

Line 2172: UPDATE mtl_material_transactions_temp mmtt

2168: l_child_pri_qty - l_parent_pri_qty,
2169: l_child_sec_qty - l_parent_sec_qty ); --bug 8197506
2170:
2171:
2172: UPDATE mtl_material_transactions_temp mmtt
2173: SET mmtt.transaction_header_id = x_new_txn_hdr_id
2174: , mmtt.primary_quantity = l_parent_pri_qty
2175: , mmtt.secondary_transaction_quantity = l_parent_sec_qty --bug 8197506
2176: , mmtt.parent_line_id = l_parent_txn_temp_id