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

Line 1405: FROM mtl_txn_request_lines mtrl

1401: LOOP
1402: BEGIN
1403: SELECT mtrl.carton_grouping_id
1404: INTO l_temp_carton_grp_id
1405: FROM mtl_txn_request_lines mtrl
1406: WHERE line_id = l_move_order_line_id_tab(i);
1407: EXCEPTION
1408: WHEN OTHERS THEN
1409: l_temp_carton_grp_id := NULL;

Line 3153: FROM mtl_txn_request_lines

3149: ship_set_id ,
3150: ship_model_id ,
3151: model_quantity ,
3152: required_quantity
3153: FROM mtl_txn_request_lines
3154: WHERE line_id = p_line_id;
3155: BEGIN
3156: debug_print( 'p_line_id ' || p_line_id);
3157: IF (p_line_id IS NOT NULL AND p_line_id <> fnd_api.g_miss_num ) THEN

Line 3876: mtl_txn_request_lines mtrl

3872: CURSOR c_mo_type
3873: IS
3874: SELECT mtrh.move_order_type
3875: FROM mtl_txn_request_headers mtrh,
3876: mtl_txn_request_lines mtrl
3877: WHERE mtrl.line_id = l_mo_line_rec.line_id
3878: AND mtrh.header_id = mtrl.header_id;
3879: CURSOR c_mmtt_info
3880: IS

Line 3997: UPDATE mtl_txn_request_lines

3993: debug_print( 'Updating Move Order Line to set Status = 5 and Qty Detailed = '
3994: || l_mo_line_rec.quantity_delivered);
3995: debug_print( 'Updating Move Order Line Quantity = ' || l_mo_line_rec.quantity_delivered);
3996: END IF;
3997: UPDATE mtl_txn_request_lines
3998: SET line_status = 5 ,
3999: quantity_detailed = NVL(quantity_delivered,0) ,
4000: quantity = NVL(quantity_delivered,0)
4001: WHERE line_id = p_line_id;

Line 4074: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec

4070: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4071: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4072: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4073: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4074: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4075: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
4076: l_mo_type NUMBER;
4077: l_wdt_count NUMBER;
4078: l_debug NUMBER;

Line 4117: FROM mtl_txn_request_lines mtrl

4113: IS
4114: SELECT mtrl.uom_code ,
4115: mtrl.transaction_source_type_id ,
4116: mtrl.transaction_type_id
4117: FROM mtl_txn_request_lines mtrl
4118: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4119: CURSOR c_get_other_mmtt
4120: IS
4121: SELECT COUNT(*)

Line 4134: mtl_txn_request_lines mtrl

4130: CURSOR c_mo_type
4131: IS
4132: SELECT mtrh.move_order_type
4133: FROM mtl_txn_request_headers mtrh,
4134: mtl_txn_request_lines mtrl
4135: WHERE mtrl.line_id = l_transaction_record.move_order_line_id
4136: AND mtrh.header_id = mtrl.header_id;
4137: BEGIN
4138: x_return_status := fnd_api.g_ret_sts_success;

Line 4304: UPDATE mtl_txn_request_lines

4300: IF l_debug = 1 THEN
4301: debug_print ( 'l_transaction_record.transaction_quantity ' || l_transaction_record.transaction_quantity);
4302: debug_print ( 'l_transaction_record.move_order_line_id ' || l_transaction_record.move_order_line_id);
4303: END IF;
4304: UPDATE mtl_txn_request_lines
4305: SET quantity_detailed = quantity_detailed - l_transaction_record.transaction_quantity
4306: WHERE line_id = l_transaction_record.move_order_line_id;
4307: IF SQL%ROWCOUNT = 0 THEN
4308: IF l_debug = 1 THEN

Line 4466: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec

4462: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4463: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4464: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4465: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4466: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4467: l_debug NUMBER;
4468: exc_not_deleted EXCEPTION;
4469: CURSOR c_mmtt_info
4470: IS

Line 4504: FROM mtl_txn_request_lines mtrl

4500: IS
4501: SELECT mtrl.uom_code ,
4502: mtrl.transaction_source_type_id ,
4503: mtrl.transaction_type_id
4504: FROM mtl_txn_request_lines mtrl
4505: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4506: CURSOR c_get_other_mmtt
4507: IS
4508: SELECT COUNT(*)

Line 4608: UPDATE mtl_txn_request_lines

4604: IF (l_debug = 1) THEN
4605: debug_print ( 'delete_mo: l_progress: ' || l_progress );
4606: debug_print ('delete_mo: l_transaction_record.move_order_line_id' || l_transaction_record.move_order_line_id );
4607: END IF;
4608: UPDATE mtl_txn_request_lines
4609: SET quantity_detailed = nvl(quantity_delivered,0),
4610: line_status = 5 ,
4611: last_update_date = SYSDATE
4612: WHERE line_id = l_transaction_record.move_order_line_id;

Line 4690: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec

4686: x_msg_data VARCHAR2(50);
4687: l_return_status VARCHAR2(1);
4688: l_transaction_number NUMBER ;
4689: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4690: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4691: l_op_plan_rec wms_op_plan_instances%rowtype ; --WOPI rec
4692: exc_not_deleted EXCEPTION;
4693: l_op_plan_status NUMBER ;
4694: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;

Line 4732: FROM mtl_txn_request_lines mtrl

4728: SELECT mtrl.uom_code ,
4729: mtrl.transaction_source_type_id ,
4730: mtrl.transaction_type_id ,
4731: backorder_delivery_detail_id
4732: FROM mtl_txn_request_lines mtrl
4733: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4734: CURSOR c_get_other_mmtt
4735: IS
4736: SELECT COUNT(*)

Line 4914: UPDATE mtl_txn_request_lines

4910: IF (l_debug = 1) THEN
4911: debug_print( 'delete_inbound_tasks: Number of MMTTs other than this MMTT : ' || l_other_mmtt_count);
4912: END IF;
4913: IF l_other_mmtt_count > 0 THEN
4914: UPDATE mtl_txn_request_lines
4915: SET quantity_detailed = quantity_detailed - l_transaction_record.primary_quantity
4916: WHERE line_id = l_transaction_record.move_order_line_id;
4917: ELSE --IF l_other_mmtt_count > 0
4918: UPDATE mtl_txn_request_lines

Line 4918: UPDATE mtl_txn_request_lines

4914: UPDATE mtl_txn_request_lines
4915: SET quantity_detailed = quantity_detailed - l_transaction_record.primary_quantity
4916: WHERE line_id = l_transaction_record.move_order_line_id;
4917: ELSE --IF l_other_mmtt_count > 0
4918: UPDATE mtl_txn_request_lines
4919: SET quantity_detailed = null
4920: WHERE line_id = l_transaction_record.move_order_line_id;
4921: END IF;
4922: IF SQL%ROWCOUNT =0 THEN

Line 5321: SELECT 1 FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mtrl

5317:
5318: c_cd_exist number;
5319:
5320: CURSOR c_cd_task (p_transaction_number IN NUMBER) IS
5321: SELECT 1 FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mtrl
5322: WHERE mtrl.backorder_delivery_detail_id IS NOT NULL
5323: AND mtrl.line_id = mmtt.move_order_line_id
5324: AND transaction_temp_id = p_transaction_number;
5325: --added for completed tasks under bug 6854145

Line 5330: SELECT 1 FROM wms_dispatched_tasks_history wdth,mtl_txn_request_lines mtrl

5326: --start changes 6854145
5327: l_mmt_rec mtl_material_transactions%ROWTYPE;
5328: l_wdth_rec wms_dispatched_tasks_history%ROWTYPE;
5329: CURSOR c_cd_task1 (p_transaction_number IN NUMBER) IS
5330: SELECT 1 FROM wms_dispatched_tasks_history wdth,mtl_txn_request_lines mtrl
5331: WHERE mtrl.backorder_delivery_detail_id IS NOT NULL
5332: AND mtrl.line_id = wdth.move_order_line_id
5333: AND transaction_id = p_transaction_number;
5334: --end changes 6854145