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 3064: FROM mtl_txn_request_lines

3060: ship_set_id ,
3061: ship_model_id ,
3062: model_quantity ,
3063: required_quantity
3064: FROM mtl_txn_request_lines
3065: WHERE line_id = p_line_id;
3066: BEGIN
3067: debug_print( 'p_line_id ' || p_line_id);
3068: IF (p_line_id IS NOT NULL AND p_line_id <> fnd_api.g_miss_num ) THEN

Line 3787: mtl_txn_request_lines mtrl

3783: CURSOR c_mo_type
3784: IS
3785: SELECT mtrh.move_order_type
3786: FROM mtl_txn_request_headers mtrh,
3787: mtl_txn_request_lines mtrl
3788: WHERE mtrl.line_id = l_mo_line_rec.line_id
3789: AND mtrh.header_id = mtrl.header_id;
3790: CURSOR c_mmtt_info
3791: IS

Line 3908: UPDATE mtl_txn_request_lines

3904: debug_print( 'Updating Move Order Line to set Status = 5 and Qty Detailed = '
3905: || l_mo_line_rec.quantity_delivered);
3906: debug_print( 'Updating Move Order Line Quantity = ' || l_mo_line_rec.quantity_delivered);
3907: END IF;
3908: UPDATE mtl_txn_request_lines
3909: SET line_status = 5 ,
3910: quantity_detailed = NVL(quantity_delivered,0) ,
3911: quantity = NVL(quantity_delivered,0)
3912: WHERE line_id = p_line_id;

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

3981: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
3982: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
3983: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
3984: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
3985: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
3986: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
3987: l_mo_type NUMBER;
3988: l_wdt_count NUMBER;
3989: l_debug NUMBER;

Line 4028: FROM mtl_txn_request_lines mtrl

4024: IS
4025: SELECT mtrl.uom_code ,
4026: mtrl.transaction_source_type_id ,
4027: mtrl.transaction_type_id
4028: FROM mtl_txn_request_lines mtrl
4029: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4030: CURSOR c_get_other_mmtt
4031: IS
4032: SELECT COUNT(*)

Line 4045: mtl_txn_request_lines mtrl

4041: CURSOR c_mo_type
4042: IS
4043: SELECT mtrh.move_order_type
4044: FROM mtl_txn_request_headers mtrh,
4045: mtl_txn_request_lines mtrl
4046: WHERE mtrl.line_id = l_transaction_record.move_order_line_id
4047: AND mtrh.header_id = mtrl.header_id;
4048: BEGIN
4049: x_return_status := fnd_api.g_ret_sts_success;

Line 4215: UPDATE mtl_txn_request_lines

4211: IF l_debug = 1 THEN
4212: debug_print ( 'l_transaction_record.transaction_quantity ' || l_transaction_record.transaction_quantity);
4213: debug_print ( 'l_transaction_record.move_order_line_id ' || l_transaction_record.move_order_line_id);
4214: END IF;
4215: UPDATE mtl_txn_request_lines
4216: SET quantity_detailed = quantity_detailed - l_transaction_record.transaction_quantity
4217: WHERE line_id = l_transaction_record.move_order_line_id;
4218: IF SQL%ROWCOUNT = 0 THEN
4219: IF l_debug = 1 THEN

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

4373: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
4374: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4375: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4376: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4377: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4378: l_debug NUMBER;
4379: exc_not_deleted EXCEPTION;
4380: CURSOR c_mmtt_info
4381: IS

Line 4415: FROM mtl_txn_request_lines mtrl

4411: IS
4412: SELECT mtrl.uom_code ,
4413: mtrl.transaction_source_type_id ,
4414: mtrl.transaction_type_id
4415: FROM mtl_txn_request_lines mtrl
4416: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4417: CURSOR c_get_other_mmtt
4418: IS
4419: SELECT COUNT(*)

Line 4519: UPDATE mtl_txn_request_lines

4515: IF (l_debug = 1) THEN
4516: debug_print ( 'delete_mo: l_progress: ' || l_progress );
4517: debug_print ('delete_mo: l_transaction_record.move_order_line_id' || l_transaction_record.move_order_line_id );
4518: END IF;
4519: UPDATE mtl_txn_request_lines
4520: SET quantity_detailed = nvl(quantity_delivered,0),
4521: line_status = 5 ,
4522: last_update_date = SYSDATE
4523: WHERE line_id = l_transaction_record.move_order_line_id;

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

4597: x_msg_data VARCHAR2(50);
4598: l_return_status VARCHAR2(1);
4599: l_transaction_number NUMBER ;
4600: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4601: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4602: l_op_plan_rec wms_op_plan_instances%rowtype ; --WOPI rec
4603: exc_not_deleted EXCEPTION;
4604: l_op_plan_status NUMBER ;
4605: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;

Line 4643: FROM mtl_txn_request_lines mtrl

4639: SELECT mtrl.uom_code ,
4640: mtrl.transaction_source_type_id ,
4641: mtrl.transaction_type_id ,
4642: backorder_delivery_detail_id
4643: FROM mtl_txn_request_lines mtrl
4644: WHERE mtrl.line_id = l_transaction_record.move_order_line_id;
4645: CURSOR c_get_other_mmtt
4646: IS
4647: SELECT COUNT(*)

Line 4825: UPDATE mtl_txn_request_lines

4821: IF (l_debug = 1) THEN
4822: debug_print( 'delete_inbound_tasks: Number of MMTTs other than this MMTT : ' || l_other_mmtt_count);
4823: END IF;
4824: IF l_other_mmtt_count > 0 THEN
4825: UPDATE mtl_txn_request_lines
4826: SET quantity_detailed = quantity_detailed - l_transaction_record.primary_quantity
4827: WHERE line_id = l_transaction_record.move_order_line_id;
4828: ELSE --IF l_other_mmtt_count > 0
4829: UPDATE mtl_txn_request_lines

Line 4829: UPDATE mtl_txn_request_lines

4825: UPDATE mtl_txn_request_lines
4826: SET quantity_detailed = quantity_detailed - l_transaction_record.primary_quantity
4827: WHERE line_id = l_transaction_record.move_order_line_id;
4828: ELSE --IF l_other_mmtt_count > 0
4829: UPDATE mtl_txn_request_lines
4830: SET quantity_detailed = null
4831: WHERE line_id = l_transaction_record.move_order_line_id;
4832: END IF;
4833: IF SQL%ROWCOUNT =0 THEN

Line 5232: SELECT 1 FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mtrl

5228:
5229: c_cd_exist number;
5230:
5231: CURSOR c_cd_task (p_transaction_number IN NUMBER) IS
5232: SELECT 1 FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mtrl
5233: WHERE mtrl.backorder_delivery_detail_id IS NOT NULL
5234: AND mtrl.line_id = mmtt.move_order_line_id
5235: AND transaction_temp_id = p_transaction_number;
5236: --added for completed tasks under bug 6854145

Line 5241: SELECT 1 FROM wms_dispatched_tasks_history wdth,mtl_txn_request_lines mtrl

5237: --start changes 6854145
5238: l_mmt_rec mtl_material_transactions%ROWTYPE;
5239: l_wdth_rec wms_dispatched_tasks_history%ROWTYPE;
5240: CURSOR c_cd_task1 (p_transaction_number IN NUMBER) IS
5241: SELECT 1 FROM wms_dispatched_tasks_history wdth,mtl_txn_request_lines mtrl
5242: WHERE mtrl.backorder_delivery_detail_id IS NOT NULL
5243: AND mtrl.line_id = wdth.move_order_line_id
5244: AND transaction_id = p_transaction_number;
5245: --end changes 6854145