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 138: INSERT INTO mtl_material_transactions_temp

134: p_split_pri_qty NUMBER)
135: IS
136: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
137: BEGIN
138: INSERT INTO mtl_material_transactions_temp
139: (
140: transaction_header_id
141: , transaction_temp_id
142: , source_code

Line 539: FROM mtl_material_transactions_temp

535: , parent_line_id
536: , serial_allocated_flag
537: , move_order_line_id
538: , l_g_task_loaded -- Bug# 4185621: loaded status
539: FROM mtl_material_transactions_temp
540: WHERE transaction_temp_id = p_child_temp_id);
541:
542: -- update the old line with remaining qty
543: update mtl_material_transactions_temp

Line 543: update mtl_material_transactions_temp

539: FROM mtl_material_transactions_temp
540: WHERE transaction_temp_id = p_child_temp_id);
541:
542: -- update the old line with remaining qty
543: update mtl_material_transactions_temp
544: set primary_quantity = primary_quantity-p_split_pri_qty, -- UOM
545: transaction_quantity = transaction_quantity-p_split_pri_qty
546: where transaction_temp_id = p_child_temp_id;
547:

Line 775: from mtl_material_transactions_temp

771:
772: -- get the information in parent
773: select transfer_lpn_id,nvl(lpn_id,content_lpn_id),subinventory_code,locator_id, transaction_uom
774: into l_transfer_lpn_id,l_lpn_id,l_parent_sub_code,l_parent_loc_id,l_parent_uom
775: from mtl_material_transactions_temp
776: where transaction_temp_id = p_parent_temp_id;
777:
778: IF p_child_temp_id is not null THEN
779: IF l_debug=1 THEN

Line 784: UPDATE mtl_material_transactions_temp mmtt

780: mydebug('update child line '||p_child_temp_id||' with parent info and new header id '||p_new_txn_hdr_id,l_api_name);
781: END IF;
782:
783: -- update child line with the correct parent info
784: UPDATE mtl_material_transactions_temp mmtt
785: SET mmtt.transaction_header_id = p_new_txn_hdr_id
786: , mmtt.transfer_lpn_id = l_transfer_lpn_id
787: , mmtt.lpn_id = l_lpn_id
788: , mmtt.parent_line_id = p_parent_temp_id

Line 803: UPDATE mtl_material_transactions_temp mmtt

799: -- update all child lines with the correct parent info
800: IF l_debug=1 THEN
801: mydebug('update all child lines with parent info and new header id '||p_new_txn_hdr_id,l_api_name);
802: END IF;
803: UPDATE mtl_material_transactions_temp mmtt
804: SET mmtt.transaction_header_id = p_new_txn_hdr_id
805: , mmtt.transfer_lpn_id = l_transfer_lpn_id
806: , mmtt.lpn_id = l_lpn_id
807: , mmtt.parent_line_id = p_parent_temp_id

Line 827: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

823: p_pri_qty NUMBER,
824: p_txn_qty NUMBER,
825: p_lot_controlled VARCHAR2
826: ) IS
827: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
828: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
829: l_new_temp_id NUMBER;
830: l_api_name VARCHAR2(30) := 'create_sub_transfer';
831: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 845: from mtl_material_transactions_temp

841: -- need to copy the child line since the child line contains the neccessary info
842: -- which the sub transfer needs
843: select *
844: into l_mmtt_rec
845: from mtl_material_transactions_temp
846: where transaction_temp_id <> p_from_temp_id
847: and parent_line_id = p_from_temp_id
848: and rownum <2;
849:

Line 943: FROM mtl_material_transactions_temp mmtt

939: , mmtt.transfer_lpn_id
940: , mmtt.transaction_uom
941: , mmtt.transaction_quantity
942: , mmtt.primary_quantity
943: FROM mtl_material_transactions_temp mmtt
944: WHERE mmtt.transaction_header_id = p_txn_hdr_id
945: AND mmtt.organization_id = p_org_id
946: AND mmtt.transaction_quantity > 0
947: AND mmtt.parent_line_id = mmtt.transaction_temp_id -- make sure it is only parent lines

Line 960: FROM mtl_material_transactions_temp mmtt

956: , mmtt.transfer_lpn_id
957: , mmtt.transaction_uom
958: , mmtt.transaction_quantity
959: , mmtt.primary_quantity
960: FROM mtl_material_transactions_temp mmtt
961: WHERE mmtt.transaction_header_id = p_txn_hdr_id
962: AND mmtt.organization_id = p_org_id
963: AND mmtt.transaction_quantity > 0
964: AND mmtt.parent_line_id <> p_temp_id

Line 977: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt

973: , mmtt.transfer_lpn_id
974: , mtlt.lot_number
975: , mtlt.transaction_quantity lot_trx_qty
976: , mtlt.primary_quantity lot_primary_qty
977: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt
978: WHERE mmtt.transaction_header_id = p_txn_hdr_id
979: AND mmtt.organization_id = p_org_id
980: AND mmtt.transaction_quantity > 0
981: AND mmtt.parent_line_id = mmtt.transaction_temp_id

Line 991: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt

987: , mmtt.transfer_lpn_id
988: , mtlt.lot_number
989: , mtlt.transaction_quantity lot_trx_qty
990: , mtlt.primary_quantity lot_primary_qty
991: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt
992: WHERE mmtt.transaction_header_id = p_txn_hdr_id
993: AND mmtt.organization_id = p_org_id
994: AND mmtt.transaction_quantity > 0
995: AND mmtt.parent_line_id <> p_temp_id

Line 1006: FROM mtl_material_transactions_temp mmtt

1002: SELECT mmtt.transaction_temp_id
1003: , mmtt.transaction_uom
1004: , mmtt.transaction_quantity
1005: , mmtt.primary_quantity
1006: FROM mtl_material_transactions_temp mmtt
1007: WHERE mmtt.parent_line_id = p_temp_id
1008: AND mmtt.parent_line_id <> mmtt.transaction_temp_id -- exclude the parent line
1009: AND mmtt.organization_id = p_org_id
1010: ORDER BY mmtt.transaction_quantity DESC;

Line 1017: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,

1013: SELECT mmtt.transaction_temp_id
1014: , mmtt.transaction_uom
1015: , mmtt.transaction_quantity
1016: , mmtt.primary_quantity
1017: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,
1018: wsh_delivery_details wdd,wsh_delivery_assignments_v wda
1019: WHERE mmtt.parent_line_id = p_temp_id
1020: AND mmtt.parent_line_id <> mmtt.transaction_temp_id -- exclude the parent line
1021: AND mmtt.organization_id = p_org_id

Line 1033: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,

1029: SELECT mmtt.transaction_temp_id
1030: , mmtt.transaction_uom
1031: , mmtt.transaction_quantity
1032: , mmtt.primary_quantity
1033: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,
1034: wsh_delivery_details wdd,wsh_delivery_assignments_v wda,
1035: oe_order_lines_all ol,mtl_txn_request_headers moh
1036: WHERE mmtt.parent_line_id = p_temp_id
1037: AND mmtt.parent_line_id <> mmtt.transaction_temp_id -- exclude the parent line

Line 1135: FROM mtl_material_transactions_temp mmtt

1131: -- get the transaction action to be used later on
1132: BEGIN
1133: SELECT transaction_action_id
1134: INTO l_transaction_action_id
1135: FROM mtl_material_transactions_temp mmtt
1136: WHERE
1137: mmtt.transaction_temp_id = p_temp_id;
1138: EXCEPTION
1139: WHEN NO_DATA_FOUND THEN -- when the line merged from APL and old temp id is not there any more

Line 1142: FROM mtl_material_transactions_temp mmtt

1138: EXCEPTION
1139: WHEN NO_DATA_FOUND THEN -- when the line merged from APL and old temp id is not there any more
1140: SELECT transaction_action_id,transaction_temp_id
1141: INTO l_transaction_action_id,l_temp_id
1142: FROM mtl_material_transactions_temp mmtt
1143: WHERE transaction_header_id = p_txn_hdr_id
1144: and rownum<2;
1145: END;
1146:

Line 1163: UPDATE mtl_material_transactions_temp

1159: -- update all child line with the correct parent info
1160: update_child(null,l_temp_id,x_new_txn_hdr_id);
1161:
1162: --Bug# 4185621: update parent line posting flag back to 'N'
1163: UPDATE mtl_material_transactions_temp
1164: SET posting_flag = 'N'
1165: WHERE transaction_temp_id = l_temp_id
1166: AND parent_line_id = transaction_temp_id;
1167: -- Bug# 4185621: end change

Line 1206: UPDATE mtl_material_transactions_temp

1202: , c_parent_lines_rec.lot_primary_qty
1203: , l_search_sequence);
1204:
1205: --Bug# 4185621: update parent line posting flag back to 'N'
1206: UPDATE mtl_material_transactions_temp
1207: SET posting_flag = 'N'
1208: WHERE transaction_temp_id = c_parent_lines_rec.transaction_temp_id
1209: AND parent_line_id = transaction_temp_id;
1210: -- Bug# 4185621: end change

Line 1232: UPDATE mtl_material_transactions_temp

1228: , c_parent_lines_rec.lot_primary_qty
1229: , l_search_sequence);
1230:
1231: --Bug# 4185621: update parent line posting flag back to 'N'
1232: UPDATE mtl_material_transactions_temp
1233: SET posting_flag = 'N'
1234: WHERE transaction_temp_id = c_parent_lines_rec.transaction_temp_id
1235: AND parent_line_id = transaction_temp_id;
1236: -- Bug# 4185621: end change

Line 1294: update mtl_material_transactions_temp

1290: l_link_mtlt_needed := 'Y'; -- remember it since the mtlt may be needed splitting
1291: IF (l_debug = 1) THEN mydebug(' child line created before id:'|| l_child_txn_temp_id,l_api_name);
1292: END IF;
1293: -- update the qty with the new process qty
1294: update mtl_material_transactions_temp
1295: set primary_quantity = primary_quantity+l_process_qty
1296: , transaction_quantity = transaction_quantity+l_process_qty
1297: , posting_flag = 'Y' -- Bug# 4185621: change child line posting flag back to 'Y'
1298: , wms_task_status = l_g_task_loaded -- Bug# 4185621: make sure child line task status is loaded

Line 1393: DELETE FROM mtl_material_transactions_temp mmtt

1389:
1390: END LOOP; -- for mtlt,c_child_lots_rec
1391:
1392: -- delete the qty 0 mmtt due to the split
1393: DELETE FROM mtl_material_transactions_temp mmtt
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

Line 1466: UPDATE mtl_material_transactions_temp

1462: EXIT WHEN c_parent_mmtt_lines%NOTFOUND;
1463: END IF;
1464:
1465: --Bug# 4185621: update parent line posting flag back to 'N'
1466: UPDATE mtl_material_transactions_temp
1467: SET posting_flag = 'N'
1468: WHERE transaction_temp_id = l_parent_txn_temp_id
1469: AND parent_line_id = transaction_temp_id;
1470: -- Bug# 4185621: end change

Line 1511: UPDATE mtl_material_transactions_temp mmtt

1507: l_child_uom := l_parent_uom ; --bug#6848907.child qty is in parent uom now
1508: END IF;
1509:
1510: IF l_parent_txn_qty >= l_child_txn_qty THEN
1511: UPDATE mtl_material_transactions_temp mmtt
1512: SET mmtt.transaction_header_id = x_new_txn_hdr_id
1513: , mmtt.transfer_lpn_id = l_transfer_lpn_id
1514: , mmtt.lpn_id = l_lpn_id
1515: , mmtt.parent_line_id = l_parent_txn_temp_id

Line 1542: UPDATE mtl_material_transactions_temp mmtt

1538: l_new_temp_id,
1539: l_child_pri_qty - l_parent_pri_qty
1540: );
1541:
1542: UPDATE mtl_material_transactions_temp mmtt
1543: SET mmtt.transaction_header_id = x_new_txn_hdr_id
1544: , mmtt.primary_quantity = l_parent_pri_qty
1545: , mmtt.parent_line_id = l_parent_txn_temp_id
1546: , mmtt.transfer_lpn_id = l_transfer_lpn_id