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 314: FROM mtl_material_transactions_temp mmtt,

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

Line 339: FROM mtl_material_transactions_temp mmtt,

335: SELECT pmmtt.subinventory_code del_subinventory,
336: pmmtt.locator_id del_locator_id,
337: Nvl(mil.inventory_location_type, 3) del_locator_type,
338: Sysdate creation_date
339: FROM mtl_material_transactions_temp mmtt,
340: mtl_material_transactions_temp pmmtt,
341: wsh_delivery_details wdd,
342: wsh_delivery_assignments_v wda,
343: mtl_item_locations mil,

Line 340: mtl_material_transactions_temp pmmtt,

336: pmmtt.locator_id del_locator_id,
337: Nvl(mil.inventory_location_type, 3) del_locator_type,
338: Sysdate creation_date
339: FROM mtl_material_transactions_temp mmtt,
340: mtl_material_transactions_temp pmmtt,
341: wsh_delivery_details wdd,
342: wsh_delivery_assignments_v wda,
343: mtl_item_locations mil,
344: mtl_secondary_inventories msi

Line 396: FROM mtl_material_transactions_temp mmtt,

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

Line 424: FROM mtl_material_transactions_temp mmtt,

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

Line 425: mtl_material_transactions_temp pmmtt,

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

Line 467: mtl_material_transactions_temp mmtt

463: mil.dropping_order,
464: mil.picking_order
465: FROM mtl_item_locations mil,
466: mtl_secondary_inventories msi,
467: mtl_material_transactions_temp mmtt
468: WHERE mmtt.transaction_temp_id = p_task_id
469: AND mil.subinventory_code = mmtt.transfer_subinventory
470: AND mil.organization_id = mmtt.organization_id
471: AND nvl(mil.inventory_location_type, 3)= G_LOC_TYPE_CONSOLIDATION -- consolidation locator

Line 479: FROM mtl_material_transactions_temp mmtt2,

475: AND msi.organization_id = mil.organization_id
476: AND nvl(msi.disable_date, trunc(sysdate + 1)) > trunc(sysdate)
477: -- bug 4017457
478: AND NOT exists (SELECT 1
479: FROM mtl_material_transactions_temp mmtt2,
480: wsh_delivery_details wdd
481: WHERE mmtt2.move_order_line_id = wdd.move_order_line_id AND
482: wdd.released_status = 'S' AND
483: mmtt2.transfer_organization = mil.organization_id AND

Line 487: FROM mtl_material_transactions_temp mmtt3,

483: mmtt2.transfer_organization = mil.organization_id AND
484: mmtt2.transfer_subinventory = mil.subinventory_code AND
485: mmtt2.transfer_to_location = mil.inventory_location_id)
486: AND NOT exists (SELECT 1
487: FROM mtl_material_transactions_temp mmtt3,
488: mtl_material_transactions_temp pmmtt2,
489: wsh_delivery_details wdd
490: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
491: wdd.released_status = 'S' AND

Line 488: mtl_material_transactions_temp pmmtt2,

484: mmtt2.transfer_subinventory = mil.subinventory_code AND
485: mmtt2.transfer_to_location = mil.inventory_location_id)
486: AND NOT exists (SELECT 1
487: FROM mtl_material_transactions_temp mmtt3,
488: mtl_material_transactions_temp pmmtt2,
489: wsh_delivery_details wdd
490: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
491: wdd.released_status = 'S' AND
492: pmmtt2.transaction_temp_id = mmtt3.parent_line_id AND

Line 504: mtl_material_transactions_temp mmtt,

500: mil.dropping_order,
501: mil.picking_order
502: FROM mtl_item_locations mil,
503: mtl_secondary_inventories msi,
504: mtl_material_transactions_temp mmtt,
505: mtl_material_transactions_temp pmmtt
506: WHERE mmtt.transaction_temp_id = p_task_id
507: AND mil.subinventory_code = pmmtt.subinventory_code
508: AND mil.organization_id = mmtt.organization_id

Line 505: mtl_material_transactions_temp pmmtt

501: mil.picking_order
502: FROM mtl_item_locations mil,
503: mtl_secondary_inventories msi,
504: mtl_material_transactions_temp mmtt,
505: mtl_material_transactions_temp pmmtt
506: WHERE mmtt.transaction_temp_id = p_task_id
507: AND mil.subinventory_code = pmmtt.subinventory_code
508: AND mil.organization_id = mmtt.organization_id
509: AND nvl(mil.inventory_location_type, 3)= G_LOC_TYPE_CONSOLIDATION -- consolidation locator

Line 518: FROM mtl_material_transactions_temp mmtt2,

514: AND nvl(msi.disable_date, trunc(sysdate + 1)) > trunc(sysdate)
515: AND pmmtt.transaction_temp_id = mmtt.parent_line_id
516: -- bug 4017457
517: AND NOT exists (SELECT 1
518: FROM mtl_material_transactions_temp mmtt2,
519: wsh_delivery_details wdd
520: WHERE mmtt2.move_order_line_id = wdd.move_order_line_id AND
521: wdd.released_status = 'S' AND
522: mmtt2.transfer_organization = mil.organization_id AND

Line 526: FROM mtl_material_transactions_temp mmtt3,

522: mmtt2.transfer_organization = mil.organization_id AND
523: mmtt2.transfer_subinventory = mil.subinventory_code AND
524: mmtt2.transfer_to_location = mil.inventory_location_id)
525: AND NOT exists (SELECT 1
526: FROM mtl_material_transactions_temp mmtt3,
527: mtl_material_transactions_temp pmmtt2,
528: wsh_delivery_details wdd
529: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
530: wdd.released_status = 'S' AND

Line 527: mtl_material_transactions_temp pmmtt2,

523: mmtt2.transfer_subinventory = mil.subinventory_code AND
524: mmtt2.transfer_to_location = mil.inventory_location_id)
525: AND NOT exists (SELECT 1
526: FROM mtl_material_transactions_temp mmtt3,
527: mtl_material_transactions_temp pmmtt2,
528: wsh_delivery_details wdd
529: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
530: wdd.released_status = 'S' AND
531: pmmtt2.transaction_temp_id = mmtt3.parent_line_id AND

Line 847: mtl_material_transactions_temp mmtt

843: INTO
844: l_pick_release_subinventory,
845: l_pick_release_locator_id
846: FROM
847: mtl_material_transactions_temp mmtt
848: WHERE mmtt.transaction_temp_id = p_task_id;
849:
850: l_progress := '110';
851:

Line 858: mtl_material_transactions_temp mmtt

854: SELECT 1
855: INTO l_cons_loc_exists_flag
856: FROM mtl_item_locations mil,
857: mtl_secondary_inventories msi,
858: mtl_material_transactions_temp mmtt
859: WHERE mmtt.transaction_temp_id = p_task_id
860: AND mil.subinventory_code = mmtt.transfer_subinventory
861: AND mil.organization_id = mmtt.organization_id
862: AND nvl(inventory_location_type, 3)= G_LOC_TYPE_CONSOLIDATION -- consolidation locator

Line 873: mtl_material_transactions_temp mmtt,

869: SELECT 1
870: INTO l_cons_loc_exists_flag
871: FROM mtl_item_locations mil,
872: mtl_secondary_inventories msi,
873: mtl_material_transactions_temp mmtt,
874: mtl_material_transactions_temp pmmtt
875: WHERE mmtt.transaction_temp_id = p_task_id
876: AND pmmtt.transaction_temp_id = mmtt.parent_line_id
877: AND mil.subinventory_code = pmmtt.subinventory_code

Line 874: mtl_material_transactions_temp pmmtt

870: INTO l_cons_loc_exists_flag
871: FROM mtl_item_locations mil,
872: mtl_secondary_inventories msi,
873: mtl_material_transactions_temp mmtt,
874: mtl_material_transactions_temp pmmtt
875: WHERE mmtt.transaction_temp_id = p_task_id
876: AND pmmtt.transaction_temp_id = mmtt.parent_line_id
877: AND mil.subinventory_code = pmmtt.subinventory_code
878: AND mil.organization_id = mmtt.organization_id

Line 1186: mtl_material_transactions_temp mmtt,

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

Line 1212: mtl_material_transactions_temp mmtt,

1208: mil.project_id,
1209: mil.task_id,
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,

Line 1213: mtl_material_transactions_temp pmmtt,

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

Line 1696: mtl_material_transactions_temp mmtt,

1692: l_pick_release_subinventory,
1693: l_pick_release_locator_id,
1694: l_pick_release_locator_type
1695: FROM
1696: mtl_material_transactions_temp mmtt,
1697: mtl_item_locations mil
1698: WHERE mmtt.transaction_temp_id = p_task_id
1699: AND mil.inventory_location_id = mmtt.transfer_to_location
1700: AND mil.organization_id = mmtt.organization_id

Line 1712: mtl_material_transactions_temp mmtt,

1708: l_pick_release_subinventory,
1709: l_pick_release_locator_id,
1710: l_pick_release_locator_type
1711: FROM
1712: mtl_material_transactions_temp mmtt,
1713: mtl_material_transactions_temp pmmtt,
1714: mtl_item_locations mil
1715: WHERE mmtt.transaction_temp_id = p_task_id
1716: AND mmtt.parent_line_id = pmmtt.transaction_temp_id

Line 1713: mtl_material_transactions_temp pmmtt,

1709: l_pick_release_locator_id,
1710: l_pick_release_locator_type
1711: FROM
1712: mtl_material_transactions_temp mmtt,
1713: mtl_material_transactions_temp pmmtt,
1714: mtl_item_locations mil
1715: WHERE mmtt.transaction_temp_id = p_task_id
1716: AND mmtt.parent_line_id = pmmtt.transaction_temp_id
1717: AND mil.inventory_location_id = pmmtt.locator_id

Line 1926: FROM mtl_material_transactions_temp mmtt,

1922: INTO l_to_sub_code,
1923: l_to_loc_id,
1924: l_organization_id,
1925: l_delivery_id
1926: FROM mtl_material_transactions_temp mmtt,
1927: wsh_delivery_details wdd,
1928: wsh_delivery_assignments_v wda
1929: WHERE mmtt.transaction_temp_id = p_task_id
1930: AND wdd.move_order_line_id = mmtt.move_order_line_id