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_WAVE_PLANNING_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 39: TYPE mtrlTblTyp is table of mtl_txn_request_lines%rowtype index by binary_integer;

35:
36: TYPE troLineRecTabTyp IS TABLE OF troLineRecTyp INDEX BY BINARY_INTEGER;
37: g_troline_table troLineRecTabTyp;
38:
39: TYPE mtrlTblTyp is table of mtl_txn_request_lines%rowtype index by binary_integer;
40: g_mtrl_tbl mtrlTblTyp;
41:
42: TYPE psrTyp IS RECORD(
43: attribute NUMBER,

Line 2682: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL INTO l_seq_val FROM dual; -- Changed

2678:
2679:
2680: for i in g_troline_table.FIRST .. g_troline_table.LAST loop
2681:
2682: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL INTO l_seq_val FROM dual; -- Changed
2683: l_line_id := l_seq_val;
2684:
2685: g_mtrl_tbl(i).LINE_ID := l_line_id;
2686: g_mtrl_tbl(i).HEADER_ID := l_mo_header_id;

Line 2951: insert into mtl_txn_request_lines values g_mtrl_tbl (i);

2947: print_debug('g_mtrl_tbl.first: '||g_mtrl_tbl.first||' g_mtrl_tbl.last: '||g_mtrl_tbl.last||' g_mtrl_tbl.count: '||g_mtrl_tbl.count,l_debug);
2948:
2949: -- for each WDD in the current wave insert record in MTRL with following values:
2950: Forall i in g_mtrl_tbl.first .. g_mtrl_tbl.last
2951: insert into mtl_txn_request_lines values g_mtrl_tbl (i);
2952:
2953: l_mtrl_count := SQL%ROWCOUNT;
2954: print_debug( l_mtrl_count||' move order lines inserted INTO MTRL', l_debug);
2955:

Line 3992: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr

3988: pick_methodology_id, container_item_id, carton_grouping_id, FND_API.G_MISS_CHAR, FND_API.G_MISS_CHAR,
3989: FND_API.G_MISS_CHAR, inspection_status, wms_process_flag, pick_slip_number, pick_slip_date,
3990: ship_set_id, ship_model_id, model_quantity, required_quantity, secondary_quantity,
3991: secondary_uom_code, secondary_quantity_detailed, secondary_quantity_delivered, grade_code, secondary_required_quantity
3992: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr
3993: WHERE mtrl.TXN_SOURCE_LINE_DETAIL_ID = wwr.delivery_detail_id
3994: AND p_mode = 'RBP'
3995: and wwr.wave_header_id=p_wave_id
3996: AND mtrl.inventory_item_id = v_inventory_item_id

Line 4018: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr, wsh_delivery_details wdd

4014: mtrl.pick_methodology_id, mtrl.container_item_id, mtrl.carton_grouping_id, FND_API.G_MISS_CHAR, FND_API.G_MISS_CHAR,
4015: FND_API.G_MISS_CHAR, mtrl.inspection_status, mtrl.wms_process_flag, mtrl.pick_slip_number, mtrl.pick_slip_date,
4016: mtrl.ship_set_id, mtrl.ship_model_id, mtrl.model_quantity, mtrl.required_quantity, mtrl.secondary_quantity,
4017: mtrl.secondary_uom_code, mtrl.secondary_quantity_detailed, mtrl.secondary_quantity_delivered, mtrl.grade_code, mtrl.secondary_required_quantity
4018: FROM mtl_txn_request_lines mtrl, wms_wp_rules_simulation wwr, wsh_delivery_details wdd
4019: WHERE mtrl.TXN_SOURCE_LINE_DETAIL_ID = wwr.delivery_detail_id
4020: AND wwr.delivery_detail_id = wdd.delivery_detail_id
4021: AND p_mode = 'RBP-SS'
4022: and wwr.wave_header_id=p_wave_id

Line 4178: update mtl_txn_request_lines

4174: --l_set_process := l_start_process;
4175: --loop through all move order lines for this ship set
4176: LOOP
4177: l_mo_line := l_mo_line_tbl(l_set_index);
4178: update mtl_txn_request_lines
4179: set quantity = 0,
4180: quantity_detailed = 0,
4181: secondary_quantity = decode(secondary_quantity, fnd_api.g_miss_num, NULL, 0),
4182: secondary_quantity_detailed = decode(secondary_quantity_detailed, fnd_api.g_miss_num, NULL, 0),

Line 4308: update mtl_txn_request_lines

4304:
4305: -- Update mo line with new quantity and model quantity;
4306: --If mo line quantity is 0, close the move order line
4307: IF l_new_line_quantity = 0 THEN
4308: update mtl_txn_request_lines
4309: set quantity = 0,
4310: quantity_detailed = 0,
4311: line_status = 5,
4312: status_date = sysdate,

Line 4319: update mtl_txn_request_lines

4315:
4316: l_mo_line_tbl(l_set_index).quantity_detailed := 0;
4317: l_mo_line_tbl(l_set_index).line_status := 5;
4318: ELSE
4319: update mtl_txn_request_lines
4320: set quantity = l_new_line_quantity,
4321: quantity_detailed = NULL,
4322: model_quantity = l_new_model_quantity
4323: where line_id = l_mo_line.line_id;

Line 4644: mtl_txn_request_lines mtrl

4640: sum(transaction_quantity) l_quantity,
4641: sum(secondary_transaction_quantity) l_quantity2
4642: from wms_wp_rules_simulation wwr,
4643: mtl_material_transactions_temp mmtt,
4644: mtl_txn_request_lines mtrl
4645: where wwr.delivery_detail_id = mtrl.TXN_SOURCE_LINE_DETAIL_ID
4646: and wwr.wave_header_id=p_wave_header_id
4647: AND mtrl.line_Id = mmtt.move_order_line_id
4648: and (mmtt.parent_line_id IS NULL OR

Line 4897: DELETE FROM mtl_txn_request_Lines WHERE header_id=p_mo_header_id;

4893: print_debug(SQL%ROWCOUNT || ' Rows deleted from MMTT ',l_debug);
4894:
4895: END IF;
4896:
4897: DELETE FROM mtl_txn_request_Lines WHERE header_id=p_mo_header_id;
4898:
4899: print_debug(SQL%ROWCOUNT || ' Rows deleted from MTRL ', l_debug);
4900:
4901: DELETE FROM mtl_txn_request_headers WHERE header_id=p_mo_header_id;

Line 9379: mtl_txn_request_lines mtrl,

9375:
9376: CURSOR c_carton_grouping_id IS
9377: SELECT DISTINCT carton_grouping_id
9378: FROM wms_waveplan_tasks_temp wwtt,
9379: mtl_txn_request_lines mtrl,
9380: wsh_Delivery_details wdd
9381: WHERE wwtt.move_order_line_id = mtrl.line_id
9382: and wdd.source_line_id = wwtt.transaction_source_line_id
9383: and wwtt.transaction_temp_id in

Line 9393: mtl_txn_request_lines mtrl,

9389:
9390: CURSOR c_rc_wdds is
9391: SELECT distinct wdd.delivery_detail_id
9392: FROM mtl_material_transactions_temp mmtt,
9393: mtl_txn_request_lines mtrl,
9394: wsh_Delivery_details wdd
9395: WHERE mmtt.move_order_line_id = mtrl.line_id
9396: AND wdd.source_line_id = mmtt.trx_source_line_id
9397: AND Nvl(wdd.REPLENISHMENT_STATUS, 'C') = 'C'

Line 9411: MTL_TXN_REQUEST_LINES MTRL,

9407: WHERE WDD.REPLENISHMENT_STATUS = 'R'
9408: AND (WDD.BATCH_ID IN
9409: ( SELECT WDD.BATCH_ID --bug14534180
9410: FROM WSH_DELIVERY_DETAILS WDD,
9411: MTL_TXN_REQUEST_LINES MTRL,
9412: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
9413: WHERE MMTT.MOVE_ORDER_LINE_ID = MTRL.LINE_ID
9414: AND WDD.SOURCE_LINE_ID = MMTT.TRX_SOURCE_LINE_ID
9415: AND MTRL.CARTON_GROUPING_ID = p_carton_grouping_id))

Line 9423: MTL_TXN_REQUEST_LINES MTRL,

9419: WHERE WDD.REPLENISHMENT_STATUS = 'R'
9420: AND (WDD.BATCH_ID IN
9421: ( SELECT SELECTED_BATCH_ID
9422: FROM WSH_PICKING_BATCHES WPB,
9423: MTL_TXN_REQUEST_LINES MTRL,
9424: WSH_DELIVERY_DETAILS WDD2,
9425: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
9426: WHERE MMTT.MOVE_ORDER_LINE_ID = MTRL.LINE_ID
9427: AND WDD2.SOURCE_LINE_ID = MMTT.TRX_SOURCE_LINE_ID

Line 9434: FROM wms_waveplan_tasks_temp wwtt, mtl_txn_request_lines mtrl

9430: );
9431:
9432: CURSOR c_rc_tasks is
9433: SELECT wwtt.transaction_temp_id
9434: FROM wms_waveplan_tasks_temp wwtt, mtl_txn_request_lines mtrl
9435: WHERE wwtt.move_order_line_id = mtrl.line_id
9436: and wwtt.transaction_temp_id in
9437: (select transaction_temp_id
9438: from wms_wp_tp_mmtt

Line 9685: from mtl_txn_request_lines

9681: (select * from table(wms_wave_planning_pvt.list_mmtt_release)); --11870443
9682:
9683: /* cursor c_move_order_header is
9684: select distinct HEADER_ID
9685: from mtl_txn_request_lines
9686: where to_char(line_id) in
9687: (SELECT TRIM(SUBSTR(txt,
9688: INSTR(txt, ',', 1, level) + 1,
9689: INSTR(txt, ',', 1, level + 1) -

Line 10505: update mtl_txn_request_lines

10501: print_DEBUG('Before Update mtrl carton grouping id to null .',
10502: l_debug);
10503:
10504: forall l2 in 1 .. p_move_order_line_tbl.count
10505: update mtl_txn_request_lines
10506: set carton_grouping_id = null
10507: where line_id = p_move_order_line_tbl(l2);
10508:
10509: print_DEBUG('After Update mtrl .', l_debug);

Line 10842: update mtl_txn_request_lines

10838: -- Stamping Move Order Header Id for all the Lines
10839:
10840: for i2 in p_move_order_line_tbl.FIRST .. p_move_order_line_tbl.LAST loop
10841:
10842: update mtl_txn_request_lines
10843: set header_id = l_x_trohdr_rec.header_id,
10844: line_number = line_count
10845: where line_id = p_move_order_line_tbl(i2);
10846: line_count := line_count + 1;

Line 10882: from mtl_txn_request_lines

10878:
10879: /*
10880: select HEADER_ID
10881: into p_move_order_hdr_tbl(i2)
10882: from mtl_txn_request_lines
10883: where line_id = p_move_order_line_tbl(i2); */
10884:
10885: -- end loop;
10886:

Line 17696: FROM mtl_txn_request_lines

17692: l_qty_det,
17693: l_sec_mol_qty,
17694: l_sec_qty_del,
17695: l_sec_qty_det
17696: FROM mtl_txn_request_lines
17697: WHERE line_id = l_mol_id;
17698:
17699:
17700: /* The below call deletes mtlt, msnt and mmtt. Takes care of everything*/

Line 17717: UPDATE mtl_txn_request_lines

17713: -- only 1 mmtt is there so close the mol
17714:
17715: IF l_sec_uom IS NULL THEN
17716:
17717: UPDATE mtl_txn_request_lines
17718: SET line_status = 5,
17719: quantity_detailed = (quantity_detailed - l_txn_qty),
17720: quantity = (quantity - l_txn_qty)
17721: WHERE line_id = l_mol_id;

Line 17724: UPDATE mtl_txn_request_lines

17720: quantity = (quantity - l_txn_qty)
17721: WHERE line_id = l_mol_id;
17722: ELSE
17723:
17724: UPDATE mtl_txn_request_lines
17725: SET line_status = 5,
17726: quantity_detailed = (quantity_detailed -
17727: l_txn_qty),
17728: secondary_quantity_detailed = (secondary_quantity_detailed -

Line 17742: UPDATE mtl_txn_request_lines

17738: -- more than 1 mmtt is there so should not close mol
17739:
17740: IF l_sec_uom IS NULL THEN
17741:
17742: UPDATE mtl_txn_request_lines
17743: SET quantity_detailed = (quantity_detailed - l_txn_qty),
17744: quantity = (quantity - l_txn_qty)
17745: WHERE line_id = l_mol_id;
17746: ELSE

Line 17748: UPDATE mtl_txn_request_lines

17744: quantity = (quantity - l_txn_qty)
17745: WHERE line_id = l_mol_id;
17746: ELSE
17747:
17748: UPDATE mtl_txn_request_lines
17749: SET quantity_detailed = (quantity_detailed -
17750: l_txn_qty),
17751: secondary_quantity_detailed = (secondary_quantity_detailed -
17752: l_sec_qty),

Line 18672: mtl_txn_request_lines mtrl,

18668: wms_dispatched_tasks wdt,
18669: bom_standard_operations bso,
18670: bom_resources br1,
18671: mtl_txn_request_headers mtrh,
18672: mtl_txn_request_lines mtrl,
18673: wms_replenishment_Details wrd
18674: where mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
18675: and mtrl.header_id = mtrh.header_id
18676: --and mtrl.line_id = mmtt.trx_source_line_id changed to move_order_line_id below

Line 19009: mtl_txn_request_lines mtrl

19005: WMS_WP_WAVE_LINES WWL,
19006: wms_dispatched_tasks wdt,
19007: bom_standard_operations bso,
19008: bom_resources br1,
19009: mtl_txn_request_lines mtrl
19010: where mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
19011: AND wdt.person_id = pap.person_id(+)
19012: AND wdt.effective_start_date >= pap.effective_start_date(+)
19013: AND wdt.effective_end_date <= pap.effective_end_date(+)

Line 19168: mtl_txn_request_lines mtrl,

19164: WMS_WP_WAVE_LINES WWL,
19165: wms_dispatched_tasks_history wdth,
19166: bom_standard_operations bso,
19167: bom_resources br1,
19168: mtl_txn_request_lines mtrl,
19169: mtl_txn_request_headers mtrh
19170: where 1=1
19171: AND wdth.person_id = pap.person_id(+)
19172: AND wdth.effective_start_date >= pap.effective_start_date(+)