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.INV_REPLENISH_DETAIL_PUB dependencies on INV_MO_LINE_DETAIL_UTIL

Line 153: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

149: l_auto_pick_confirm NUMBER;
150: l_pick_release_status inv_pick_release_pub.inv_release_status_tbl_type;
151: l_return_status VARCHAR2(1);
152: l_grouping_rule_id NUMBER;
153: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
154: l_mold_tbl_temp inv_mo_line_detail_util.g_mmtt_tbl_type;
155: l_message VARCHAR2(2000);
156: l_count NUMBER;
157: l_from_serial_number VARCHAR2(30);

Line 154: l_mold_tbl_temp inv_mo_line_detail_util.g_mmtt_tbl_type;

150: l_pick_release_status inv_pick_release_pub.inv_release_status_tbl_type;
151: l_return_status VARCHAR2(1);
152: l_grouping_rule_id NUMBER;
153: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
154: l_mold_tbl_temp inv_mo_line_detail_util.g_mmtt_tbl_type;
155: l_message VARCHAR2(2000);
156: l_count NUMBER;
157: l_from_serial_number VARCHAR2(30);
158: l_to_serial_number VARCHAR2(30);

Line 352: l_mold_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_trolin_tbl(1).line_id);

348: COMMIT;
349: IF (l_debug = 1) THEN
350: print_debug('auto pick confirm');
351: END IF;
352: l_mold_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_trolin_tbl(1).line_id);
353: l_mold_tbl_temp := l_mold_tbl;
354:
355: IF (l_mold_tbl.COUNT = 0) THEN
356: l_return_status := fnd_api.g_ret_sts_unexp_error;

Line 867: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;

863: l_error_code NUMBER;
864: l_count NUMBER;
865: l_success BOOLEAN;
866: l_umconvert_trans_quantity NUMBER := 0;
867: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
868: l_primary_uom VARCHAR2(10);
869: l_ato_item NUMBER := 0;
870: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
871: BEGIN

Line 922: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);

918: IF l_ato_item = 1 THEN
919: -- If item is ato item, reduce the detailed quantity by the transaction
920: -- quantity and retain the reservation.Convert to primary uom before
921: -- reducing detailed quantity.
922: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
923: l_umconvert_trans_quantity := p_transaction_quantity;
924:
925: IF l_mmtt_rec.inventory_item_id IS NOT NULL
926: AND l_mmtt_rec.transaction_uom IS NOT NULL THEN

Line 1024: inv_mo_line_detail_util.delete_row( x_return_status => l_return_status

1020: IF (NOT l_success) THEN
1021: RAISE fnd_api.g_exc_error;
1022: END IF;
1023:
1024: inv_mo_line_detail_util.delete_row( x_return_status => l_return_status
1025: , p_line_id => p_move_order_line_id
1026: , p_line_detail_id => p_transaction_temp_id);
1027:
1028: /* select count(1) into l_count

Line 1239: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;

1235: , x_msg_count OUT NOCOPY NUMBER
1236: , x_msg_data OUT NOCOPY VARCHAR2
1237: ) IS
1238: l_transaction_temp_id NUMBER := p_transaction_temp_id;
1239: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
1240: l_next_id NUMBER;
1241: l_return_status VARCHAR2(1);
1242: l_count NUMBER;
1243: l_primary_quantity NUMBER;

Line 1251: l_mmtt_rec := inv_mo_line_detail_util.query_row(l_transaction_temp_id);

1247: SELECT mtl_material_transactions_s.NEXTVAL
1248: INTO l_next_id
1249: FROM DUAL;
1250:
1251: l_mmtt_rec := inv_mo_line_detail_util.query_row(l_transaction_temp_id);
1252: --inv_debug.message('l_next_id ' || l_next_id);
1253: l_mmtt_rec.transaction_temp_id := l_next_id;
1254: l_mmtt_rec.transaction_quantity := p_detailed_quantity - p_transaction_quantity - p_missing_quantity;
1255:

Line 1279: inv_mo_line_detail_util.insert_row(x_return_status => l_return_status, p_mo_line_detail_rec => l_mmtt_rec);

1275: END IF;
1276:
1277: l_mmtt_rec.transaction_status := 2;
1278: l_mmtt_rec.transaction_header_id := NULL;
1279: inv_mo_line_detail_util.insert_row(x_return_status => l_return_status, p_mo_line_detail_rec => l_mmtt_rec);
1280:
1281: --inv_debug.message('after insert row '|| l_return_status );
1282: SELECT COUNT(*)
1283: INTO l_count

Line 1322: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

1318: ) IS
1319: l_line_id NUMBER := p_line_id;
1320: l_return_status VARCHAR2(1);
1321: l_grouping_rule_id NUMBER;
1322: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
1323: l_message VARCHAR2(2000);
1324: l_count NUMBER;
1325: l_from_serial_number VARCHAR2(30);
1326: l_to_serial_number VARCHAR2(30);

Line 1334: l_mold_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_line_id);

1330: --inv_debug.message('auto pick confirm');
1331: --inv_debug.message('get trolin');
1332: l_trolin_tbl := inv_trolin_util.query_rows(p_line_id => l_line_id);
1333: --inv_debug.message('get mold');
1334: l_mold_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_line_id);
1335: --inv_debug.message('number of mold record is ' || l_mold_tbl.count);
1336: inv_pick_wave_pick_confirm_pub.pick_confirm(
1337: p_api_version_number => 1.0
1338: , p_init_msg_list => fnd_api.g_false

Line 1441: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;

1437: l_return_status VARCHAR2(1);
1438: l_msg_count NUMBER;
1439: l_msg_data VARCHAR2(2000);
1440: l_error_code NUMBER;
1441: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
1442: l_mmtt_count NUMBER;
1443: l_reservation_id NUMBER := p_reservation_id;
1444: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
1445: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

Line 1472: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);

1468: l_lot_transaction_quantity NUMBER;
1469: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1470: BEGIN
1471: --inv_Debug.message('ssia', 'Inside changed_from_subinventory');
1472: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
1473:
1474: --inv_Debug.message('ssia', 'transaction_temp_id is ' || p_transaction_temp_id);
1475:
1476: SELECT reservable_type