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

Line 842: , mtl_txn_request_lines mtrl

838: wda.delivery_id,mtrl.carton_grouping_id
839: INTO l_delivery_id,l_carton_grouping_id
840: FROM
841: mtl_material_transactions_temp mmtt
842: , mtl_txn_request_lines mtrl
843: , wsh_delivery_details wdd
844: , wsh_delivery_assignments_v wda
845: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
846: AND mmtt.move_order_line_id = mtrl.line_id

Line 856: , mtl_txn_request_lines mtrl

852: mtrl.carton_grouping_id
853: INTO l_carton_grouping_id
854: FROM
855: mtl_material_transactions_temp mmtt
856: , mtl_txn_request_lines mtrl
857: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
858: AND mmtt.move_order_line_id = mtrl.line_id;
859: END IF;
860: IF l_delivery_id is not null THEN

Line 915: mtl_txn_request_lines mtrl,

911: --Resolve move_order_type from l_transaction_temp_id
912: SELECT mtrh.move_order_type
913: INTO l_move_order_type
914: FROM mtl_txn_request_headers mtrh,
915: mtl_txn_request_lines mtrl,
916: mtl_material_transactions_temp mmtt
917: WHERE mmtt.move_order_line_id = mtrl.line_id
918: AND mtrl.header_id = mtrh.header_id
919: AND mmtt.transaction_temp_id = l_transaction_temp_id;

Line 1113: , mtl_txn_request_lines mtrl

1109: FROM wms_dispatched_tasks wdt
1110: , mtl_material_transactions_temp mmtt
1111: , mtl_system_items_vl msik /* Bug 5581528 */
1112: , mtl_parameters mp
1113: , mtl_txn_request_lines mtrl
1114: , mtl_secondary_inventories msi
1115: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1116: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
1117: AND mp.organization_id = wdt.organization_id

Line 1220: , mtl_txn_request_lines mtrl

1216: FROM wms_dispatched_tasks wdt
1217: , mtl_material_transactions_temp mmtt
1218: , mtl_system_items_vl msik /* Bug 5581528 */
1219: , mtl_parameters mp
1220: , mtl_txn_request_lines mtrl
1221: , mtl_secondary_inventories msi
1222: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1223: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
1224: AND mp.organization_id = wdt.organization_id

Line 1364: , mtl_txn_request_lines mtrl

1360: SELECT DECODE (mtrh.move_order_type
1361: , inv_globals.g_move_order_mfg_pick, 'MFG'
1362: , 'OTHERS')
1363: FROM mtl_material_transactions_temp mmtt
1364: , mtl_txn_request_lines mtrl
1365: , mtl_txn_request_headers mtrh
1366: WHERE mmtt.organization_id = p_org_id
1367: AND mmtt.transfer_lpn_id = p_lpn_id
1368: AND mtrl.line_id = mmtt.move_order_line_id

Line 1380: , mtl_txn_request_lines mtrl

1376: , mtrl.txn_source_id
1377: , mtrl.txn_source_line_id
1378: , mtrl.reference_id
1379: FROM mtl_material_transactions_temp mmtt
1380: , mtl_txn_request_lines mtrl
1381: WHERE mmtt.organization_id = p_org_id
1382: AND mmtt.transfer_lpn_id = p_lpn_id
1383: AND mtrl.line_id = mmtt.move_order_line_id;
1384:

Line 1539: , mtl_txn_request_lines mtrl

1535: , mtrl.reference_id repetitive_schedule_id
1536: , mtrl.txn_source_line_id operation_seq_num
1537: , to_number(NULL) transfer_to_location --Bug#2756609
1538: FROM mtl_material_transactions_temp mmtt
1539: , mtl_txn_request_lines mtrl
1540: , wms_dispatched_tasks wdt
1541: , mtl_system_items_vl msik /* Bug 5581528 */
1542: WHERE mmtt.organization_id = p_organization_id
1543: AND mmtt.transfer_lpn_id = p_transfer_lpn_id