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_MATERIAL_TRANSACTIONS_TEMP

Line 246: mtl_material_transactions_temp mmtt,

242: mmtt.operation_plan_id,
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

Line 268: mtl_material_transactions_temp mmtt,

264: mmtt.operation_plan_id,
265: mil.project_id,
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,

Line 269: mtl_material_transactions_temp pmmtt,

265: mil.project_id,
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

Line 318: FROM mtl_material_transactions_temp mmtt,

314: SELECT mmtt.transfer_subinventory del_subinventory,
315: mmtt.transfer_to_location del_locator_id,
316: Nvl(mil.inventory_location_type, 3) del_locator_type,
317: Sysdate creation_date
318: FROM mtl_material_transactions_temp mmtt,
319: wsh_delivery_details wdd,
320: wsh_delivery_assignments_v wda,
321: mtl_item_locations mil,
322: mtl_secondary_inventories msi

Line 343: FROM mtl_material_transactions_temp mmtt,

339: SELECT pmmtt.subinventory_code del_subinventory,
340: pmmtt.locator_id del_locator_id,
341: Nvl(mil.inventory_location_type, 3) del_locator_type,
342: Sysdate creation_date
343: FROM mtl_material_transactions_temp mmtt,
344: mtl_material_transactions_temp pmmtt,
345: wsh_delivery_details wdd,
346: wsh_delivery_assignments_v wda,
347: mtl_item_locations mil,

Line 344: mtl_material_transactions_temp pmmtt,

340: pmmtt.locator_id del_locator_id,
341: Nvl(mil.inventory_location_type, 3) del_locator_type,
342: Sysdate creation_date
343: FROM mtl_material_transactions_temp mmtt,
344: mtl_material_transactions_temp pmmtt,
345: wsh_delivery_details wdd,
346: wsh_delivery_assignments_v wda,
347: mtl_item_locations mil,
348: mtl_secondary_inventories msi

Line 400: FROM mtl_material_transactions_temp mmtt,

396: SELECT mmtt.transfer_subinventory mol_subinventory,
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,

Line 428: FROM mtl_material_transactions_temp mmtt,

424: SELECT pmmtt.subinventory_code mol_subinventory,
425: pmmtt.locator_id mol_locator_id,
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,

Line 429: mtl_material_transactions_temp pmmtt,

425: pmmtt.locator_id mol_locator_id,
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,

Line 471: mtl_material_transactions_temp mmtt,wsh_delivery_details wdd1

467: mil.dropping_order,
468: mil.picking_order
469: FROM mtl_item_locations mil,
470: mtl_secondary_inventories msi,
471: mtl_material_transactions_temp mmtt,wsh_delivery_details wdd1
472: WHERE mmtt.transaction_temp_id = p_task_id
473: AND mil.subinventory_code = mmtt.transfer_subinventory
474: AND mil.organization_id = mmtt.organization_id
475: AND nvl(mil.inventory_location_type, 3)= G_LOC_TYPE_CONSOLIDATION -- consolidation locator

Line 486: FROM mtl_material_transactions_temp mmtt2,

482: AND (wdd1.project_id is NOT NULL or (wdd1.project_id IS NULL AND
483: (mil.inventory_location_id=mil.physical_location_id or mil.physical_location_id is NULL))) --bug 8657987
484: -- bug 4017457
485: AND NOT exists (SELECT 1
486: FROM mtl_material_transactions_temp mmtt2,
487: wsh_delivery_details wdd
488: WHERE mmtt2.move_order_line_id = wdd.move_order_line_id AND
489: wdd.released_status = 'S' AND
490: mmtt2.transfer_organization = mil.organization_id AND

Line 494: FROM mtl_material_transactions_temp mmtt3,

490: mmtt2.transfer_organization = mil.organization_id AND
491: mmtt2.transfer_subinventory = mil.subinventory_code AND
492: mmtt2.transfer_to_location = mil.inventory_location_id)
493: AND NOT exists (SELECT 1
494: FROM mtl_material_transactions_temp mmtt3,
495: mtl_material_transactions_temp pmmtt2,
496: wsh_delivery_details wdd
497: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
498: wdd.released_status = 'S' AND

Line 495: mtl_material_transactions_temp pmmtt2,

491: mmtt2.transfer_subinventory = mil.subinventory_code AND
492: mmtt2.transfer_to_location = mil.inventory_location_id)
493: AND NOT exists (SELECT 1
494: FROM mtl_material_transactions_temp mmtt3,
495: mtl_material_transactions_temp pmmtt2,
496: wsh_delivery_details wdd
497: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
498: wdd.released_status = 'S' AND
499: pmmtt2.transaction_temp_id = mmtt3.parent_line_id AND

Line 511: mtl_material_transactions_temp mmtt,

507: mil.dropping_order,
508: mil.picking_order
509: FROM mtl_item_locations mil,
510: mtl_secondary_inventories msi,
511: mtl_material_transactions_temp mmtt,
512: mtl_material_transactions_temp pmmtt
513: WHERE mmtt.transaction_temp_id = p_task_id
514: AND mil.subinventory_code = pmmtt.subinventory_code
515: AND mil.organization_id = mmtt.organization_id

Line 512: mtl_material_transactions_temp pmmtt

508: mil.picking_order
509: FROM mtl_item_locations mil,
510: mtl_secondary_inventories msi,
511: mtl_material_transactions_temp mmtt,
512: mtl_material_transactions_temp pmmtt
513: WHERE mmtt.transaction_temp_id = p_task_id
514: AND mil.subinventory_code = pmmtt.subinventory_code
515: AND mil.organization_id = mmtt.organization_id
516: AND nvl(mil.inventory_location_type, 3)= G_LOC_TYPE_CONSOLIDATION -- consolidation locator

Line 525: FROM mtl_material_transactions_temp mmtt2,

521: AND nvl(msi.disable_date, trunc(sysdate + 1)) > trunc(sysdate)
522: AND pmmtt.transaction_temp_id = mmtt.parent_line_id
523: -- bug 4017457
524: AND NOT exists (SELECT 1
525: FROM mtl_material_transactions_temp mmtt2,
526: wsh_delivery_details wdd
527: WHERE mmtt2.move_order_line_id = wdd.move_order_line_id AND
528: wdd.released_status = 'S' AND
529: mmtt2.transfer_organization = mil.organization_id AND

Line 533: FROM mtl_material_transactions_temp mmtt3,

529: mmtt2.transfer_organization = mil.organization_id AND
530: mmtt2.transfer_subinventory = mil.subinventory_code AND
531: mmtt2.transfer_to_location = mil.inventory_location_id)
532: AND NOT exists (SELECT 1
533: FROM mtl_material_transactions_temp mmtt3,
534: mtl_material_transactions_temp pmmtt2,
535: wsh_delivery_details wdd
536: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
537: wdd.released_status = 'S' AND

Line 534: mtl_material_transactions_temp pmmtt2,

530: mmtt2.transfer_subinventory = mil.subinventory_code AND
531: mmtt2.transfer_to_location = mil.inventory_location_id)
532: AND NOT exists (SELECT 1
533: FROM mtl_material_transactions_temp mmtt3,
534: mtl_material_transactions_temp pmmtt2,
535: wsh_delivery_details wdd
536: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
537: wdd.released_status = 'S' AND
538: pmmtt2.transaction_temp_id = mmtt3.parent_line_id AND

Line 618: mtl_material_transactions_temp mmtt

614: BEGIN
615: SELECT 1
616: INTO l_cons_loc_exists_flag
617: FROM mtl_item_locations mil,
618: mtl_material_transactions_temp mmtt
619: WHERE mmtt.transaction_temp_id = p_task_id
620: AND mil.organization_id = mmtt.organization_id
621: AND nvl(mil.inventory_location_type, 3)= G_LOC_TYPE_CONSOLIDATION -- consolidation locator
622: AND nvl(mil.disable_date, trunc(sysdate + 1)) > trunc(sysdate) ;

Line 929: mtl_material_transactions_temp mmtt

925: INTO
926: l_pick_release_subinventory,
927: l_pick_release_locator_id
928: FROM
929: mtl_material_transactions_temp mmtt
930: WHERE mmtt.transaction_temp_id = p_task_id;
931:
932: l_progress := '110';
933:

Line 940: mtl_material_transactions_temp mmtt

936: SELECT 1
937: INTO l_cons_loc_exists_flag
938: FROM mtl_item_locations mil,
939: mtl_secondary_inventories msi,
940: mtl_material_transactions_temp mmtt
941: WHERE mmtt.transaction_temp_id = p_task_id
942: AND mil.subinventory_code = mmtt.transfer_subinventory
943: AND mil.organization_id = mmtt.organization_id
944: AND nvl(inventory_location_type, 3)= G_LOC_TYPE_CONSOLIDATION -- consolidation locator

Line 955: mtl_material_transactions_temp mmtt,

951: SELECT 1
952: INTO l_cons_loc_exists_flag
953: FROM mtl_item_locations mil,
954: mtl_secondary_inventories msi,
955: mtl_material_transactions_temp mmtt,
956: mtl_material_transactions_temp pmmtt
957: WHERE mmtt.transaction_temp_id = p_task_id
958: AND pmmtt.transaction_temp_id = mmtt.parent_line_id
959: AND mil.subinventory_code = pmmtt.subinventory_code

Line 956: mtl_material_transactions_temp pmmtt

952: INTO l_cons_loc_exists_flag
953: FROM mtl_item_locations mil,
954: mtl_secondary_inventories msi,
955: mtl_material_transactions_temp mmtt,
956: mtl_material_transactions_temp pmmtt
957: WHERE mmtt.transaction_temp_id = p_task_id
958: AND pmmtt.transaction_temp_id = mmtt.parent_line_id
959: AND mil.subinventory_code = pmmtt.subinventory_code
960: AND mil.organization_id = mmtt.organization_id

Line 1270: mtl_material_transactions_temp mmtt,

1266: mil.project_id,
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,

Line 1295: mtl_material_transactions_temp mmtt,

1291: mil.project_id,
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,

Line 1322: mtl_material_transactions_temp mmtt,

1318: mil.project_id,
1319: mil.task_id,
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,

Line 1323: mtl_material_transactions_temp pmmtt,

1319: mil.task_id,
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

Line 1806: mtl_material_transactions_temp mmtt,

1802: l_pick_release_subinventory,
1803: l_pick_release_locator_id,
1804: l_pick_release_locator_type
1805: FROM
1806: mtl_material_transactions_temp mmtt,
1807: mtl_item_locations mil
1808: WHERE mmtt.transaction_temp_id = p_task_id
1809: AND mil.inventory_location_id = mmtt.transfer_to_location
1810: AND mil.organization_id = mmtt.organization_id

Line 1822: mtl_material_transactions_temp mmtt,

1818: l_pick_release_subinventory,
1819: l_pick_release_locator_id,
1820: l_pick_release_locator_type
1821: FROM
1822: mtl_material_transactions_temp mmtt,
1823: mtl_material_transactions_temp pmmtt,
1824: mtl_item_locations mil
1825: WHERE mmtt.transaction_temp_id = p_task_id
1826: AND mmtt.parent_line_id = pmmtt.transaction_temp_id

Line 1823: mtl_material_transactions_temp pmmtt,

1819: l_pick_release_locator_id,
1820: l_pick_release_locator_type
1821: FROM
1822: mtl_material_transactions_temp mmtt,
1823: mtl_material_transactions_temp pmmtt,
1824: mtl_item_locations mil
1825: WHERE mmtt.transaction_temp_id = p_task_id
1826: AND mmtt.parent_line_id = pmmtt.transaction_temp_id
1827: AND mil.inventory_location_id = pmmtt.locator_id

Line 2036: FROM mtl_material_transactions_temp mmtt,

2032: INTO l_to_sub_code,
2033: l_to_loc_id,
2034: l_organization_id,
2035: l_delivery_id
2036: FROM mtl_material_transactions_temp mmtt,
2037: wsh_delivery_details wdd,
2038: wsh_delivery_assignments_v wda
2039: WHERE mmtt.transaction_temp_id = p_task_id
2040: AND wdd.move_order_line_id = mmtt.move_order_line_id