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 373: mtl_txn_request_lines mol,

369: nvl(mil.inventory_location_type, 3) mol_locator_type,
370: wdth.creation_date
371: FROM wsh_delivery_details wdd,
372: wsh_delivery_assignments_v wda,
373: mtl_txn_request_lines mol,
374: mtl_item_locations mil,
375: mtl_secondary_inventories msi,
376: wms_dispatched_tasks_history wdth
377: WHERE

Line 397: mtl_txn_request_lines mol,

393: mmtt.transfer_to_location mol_locator_id,
394: Nvl(mil.inventory_location_type, 3) mol_locator_type,
395: Sysdate creation_date
396: FROM mtl_material_transactions_temp mmtt,
397: mtl_txn_request_lines mol,
398: wsh_delivery_details wdd,
399: wsh_delivery_assignments_v wda,
400: mtl_item_locations mil,
401: mtl_secondary_inventories msi

Line 426: mtl_txn_request_lines mol,

422: Nvl(mil.inventory_location_type, 3) mol_locator_type,
423: Sysdate creation_date
424: FROM mtl_material_transactions_temp mmtt,
425: mtl_material_transactions_temp pmmtt,
426: mtl_txn_request_lines mol,
427: wsh_delivery_details wdd,
428: wsh_delivery_assignments_v wda,
429: mtl_item_locations mil,
430: mtl_secondary_inventories msi

Line 1187: mtl_txn_request_lines mol,

1183: mil.task_id,
1184: mil.organization_id
1185: FROM
1186: mtl_material_transactions_temp mmtt,
1187: mtl_txn_request_lines mol,
1188: wsh_delivery_details wdd1,
1189: wsh_delivery_details wdd2,
1190: wsh_delivery_assignments_v wda,
1191: mtl_item_locations mil

Line 1214: mtl_txn_request_lines mol,

1210: mil.organization_id
1211: FROM
1212: mtl_material_transactions_temp mmtt,
1213: mtl_material_transactions_temp pmmtt,
1214: mtl_txn_request_lines mol,
1215: wsh_delivery_details wdd,
1216: wsh_delivery_assignments_v wda,
1217: mtl_item_locations mil
1218: WHERE

Line 1242: mtl_txn_request_lines mol,

1238: mol.project_id,
1239: mol.task_id,
1240: mol.organization_id
1241: FROM
1242: mtl_txn_request_lines mol,
1243: wsh_delivery_details wdd,
1244: wsh_delivery_assignments_v wda
1245: WHERE
1246: mol.line_id = p_mol_id AND

Line 1288: mtl_txn_request_lines mol,

1284: wdd.locator_id mol_locator_id,
1285: nvl(mil.inventory_location_type, 3) mol_locator_type
1286: FROM wsh_delivery_details wdd,
1287: wsh_delivery_assignments_v wda,
1288: mtl_txn_request_lines mol,
1289: mtl_item_locations mil,
1290: mtl_secondary_inventories msi
1291: WHERE
1292: mol.line_id = wdd.move_order_line_id AND