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

Line 247: mtl_txn_request_lines mol,

243: mil.project_id,
244: mil.task_id
245: FROM
246: mtl_material_transactions_temp mmtt,
247: mtl_txn_request_lines mol,
248: wsh_delivery_details wdd,
249: wsh_delivery_assignments_v wda,
250: mtl_item_locations mil
251: WHERE

Line 270: mtl_txn_request_lines mol,

266: mil.task_id
267: FROM
268: mtl_material_transactions_temp mmtt,
269: mtl_material_transactions_temp pmmtt,
270: mtl_txn_request_lines mol,
271: wsh_delivery_details wdd,
272: wsh_delivery_assignments_v wda,
273: mtl_item_locations mil
274: WHERE

Line 377: mtl_txn_request_lines mol,

373: nvl(mil.inventory_location_type, 3) mol_locator_type,
374: wdth.creation_date
375: FROM wsh_delivery_details wdd,
376: wsh_delivery_assignments_v wda,
377: mtl_txn_request_lines mol,
378: mtl_item_locations mil,
379: mtl_secondary_inventories msi,
380: wms_dispatched_tasks_history wdth
381: WHERE

Line 401: mtl_txn_request_lines mol,

397: mmtt.transfer_to_location mol_locator_id,
398: Nvl(mil.inventory_location_type, 3) mol_locator_type,
399: Sysdate creation_date
400: FROM mtl_material_transactions_temp mmtt,
401: mtl_txn_request_lines mol,
402: wsh_delivery_details wdd,
403: wsh_delivery_assignments_v wda,
404: mtl_item_locations mil,
405: mtl_secondary_inventories msi

Line 430: mtl_txn_request_lines mol,

426: Nvl(mil.inventory_location_type, 3) mol_locator_type,
427: Sysdate creation_date
428: FROM mtl_material_transactions_temp mmtt,
429: mtl_material_transactions_temp pmmtt,
430: mtl_txn_request_lines mol,
431: wsh_delivery_details wdd,
432: wsh_delivery_assignments_v wda,
433: mtl_item_locations mil,
434: mtl_secondary_inventories msi

Line 1271: mtl_txn_request_lines mol,

1267: mil.task_id,
1268: mil.organization_id
1269: FROM
1270: mtl_material_transactions_temp mmtt,
1271: mtl_txn_request_lines mol,
1272: wsh_delivery_details wdd1,
1273: wsh_delivery_details wdd2,
1274: wsh_delivery_assignments_v wda,
1275: mtl_item_locations mil

Line 1296: mtl_txn_request_lines mol,

1292: mil.task_id,
1293: mil.organization_id
1294: FROM
1295: mtl_material_transactions_temp mmtt,
1296: mtl_txn_request_lines mol,
1297: wsh_delivery_details wdd,
1298: wsh_delivery_assignments_v wda,
1299: mtl_item_locations mil,
1300: mtl_parameters mpara

Line 1324: mtl_txn_request_lines mol,

1320: mil.organization_id
1321: FROM
1322: mtl_material_transactions_temp mmtt,
1323: mtl_material_transactions_temp pmmtt,
1324: mtl_txn_request_lines mol,
1325: wsh_delivery_details wdd,
1326: wsh_delivery_assignments_v wda,
1327: mtl_item_locations mil
1328: WHERE

Line 1352: mtl_txn_request_lines mol,

1348: mol.project_id,
1349: mol.task_id,
1350: mol.organization_id
1351: FROM
1352: mtl_txn_request_lines mol,
1353: wsh_delivery_details wdd,
1354: wsh_delivery_assignments_v wda
1355: WHERE
1356: mol.line_id = p_mol_id AND

Line 1398: mtl_txn_request_lines mol,

1394: wdd.locator_id mol_locator_id,
1395: nvl(mil.inventory_location_type, 3) mol_locator_type
1396: FROM wsh_delivery_details wdd,
1397: wsh_delivery_assignments_v wda,
1398: mtl_txn_request_lines mol,
1399: mtl_item_locations mil,
1400: mtl_secondary_inventories msi
1401: WHERE
1402: mol.line_id = wdd.move_order_line_id AND