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_ITEM_LOCATIONS

Line 64: mtl_item_locations

60:
61: SELECT *
62: INTO l_locator_rec
63: FROM
64: mtl_item_locations
65: WHERE inventory_location_id = x_locator_id;
66:
67: IF l_locator_rec.project_id = p_project_id
68: AND l_locator_rec.task_id = p_task_id THEN

Line 81: mtl_item_locations

77: BEGIN
78: SELECT inventory_location_id
79: INTO l_locator_id
80: FROM
81: mtl_item_locations
82: WHERE physical_location_id = x_locator_id
83: AND project_id = p_project_id
84: AND NVL(task_id,-999) = NVL(p_task_id,-999) --10368799 ,added NVL
85: AND ROWNUM < 2;

Line 250: mtl_item_locations mil

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
252: mmtt.transaction_temp_id = p_task_id AND
253: mmtt.move_order_line_id = mol.line_id AND
254: mmtt.move_order_line_id = wdd.move_order_line_id AND

Line 273: mtl_item_locations mil

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
275: mmtt.transaction_temp_id = p_task_id AND
276: mmtt.move_order_line_id = mol.line_id AND
277: mmtt.move_order_line_id = wdd.move_order_line_id AND

Line 296: mtl_item_locations mil,

292: wdth.creation_date
293: FROM wsh_delivery_details wdd,
294: wsh_delivery_details wdd2,
295: wsh_delivery_assignments_v wda,
296: mtl_item_locations mil,
297: mtl_secondary_inventories msi,
298: wms_dispatched_tasks_history wdth
299: WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND
300: wdd.released_status = 'Y' AND

Line 321: mtl_item_locations mil,

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
323: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
324: mmtt.move_order_line_id = wdd.move_order_line_id AND
325: wdd.delivery_detail_id = wda.delivery_detail_id AND

Line 347: mtl_item_locations mil,

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
349: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
350: mmtt.move_order_line_id = wdd.move_order_line_id AND
351: wdd.delivery_detail_id = wda.delivery_detail_id AND

Line 378: mtl_item_locations mil,

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
382: mol.line_id = wdd.move_order_line_id AND

Line 404: mtl_item_locations mil,

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
406: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
407: mmtt.move_order_line_id = mol.line_id AND
408: mol.carton_grouping_id = v_carton_grouping_id AND

Line 433: mtl_item_locations mil,

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
435: WHERE mmtt.operation_plan_id = v_operation_plan_id AND
436: mmtt.move_order_line_id = mol.line_id AND
437: mol.carton_grouping_id = v_carton_grouping_id AND

Line 469: FROM mtl_item_locations mil,

465: SELECT mil.inventory_location_id locator_id,
466: mil.subinventory_code subinventory_code,
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

Line 509: FROM mtl_item_locations mil,

505: SELECT mil.inventory_location_id locator_id,
506: mil.subinventory_code subinventory_code,
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

Line 617: FROM mtl_item_locations mil,

613: l_progress := '15';
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

Line 938: FROM mtl_item_locations mil,

934: BEGIN
935: IF (p_call_mode <> 3) THEN
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

Line 953: FROM mtl_item_locations mil,

949: ;
950: ELSE
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

Line 1038: FROM mtl_item_locations mil,

1034: l_validate_loc_subinventory,
1035: l_validate_loc_empty_flag,
1036: l_loc_disable_date,
1037: l_sub_disable_date
1038: FROM mtl_item_locations mil,
1039: mtl_secondary_inventories msi
1040: WHERE mil.inventory_location_id = p_locator_id
1041: AND msi.secondary_inventory_name = mil.subinventory_code
1042: AND msi.organization_id = mil.organization_id

Line 1275: mtl_item_locations mil

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
1276: WHERE
1277: mmtt.transaction_temp_id = p_task_id AND
1278: wdd1.move_order_line_id = mol.line_id AND
1279: mmtt.content_lpn_id = wdd2.lpn_id AND

Line 1299: mtl_item_locations mil,

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
1301: WHERE mmtt.transaction_temp_id = p_task_id
1302: AND mmtt.move_order_line_id = mol.line_id
1303: AND mmtt.move_order_line_id = wdd.move_order_line_id

Line 1327: mtl_item_locations mil

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
1329: mmtt.transaction_temp_id = p_task_id AND
1330: mmtt.move_order_line_id = mol.line_id AND
1331: mmtt.move_order_line_id = wdd.move_order_line_id AND

Line 1371: mtl_item_locations mil,

1367: wdd.locator_id del_locator_id,
1368: nvl(mil.inventory_location_type, 3) del_locator_type
1369: FROM wsh_delivery_details wdd,
1370: wsh_delivery_assignments_v wda,
1371: mtl_item_locations mil,
1372: mtl_secondary_inventories msi
1373: WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND
1374: wdd.released_status = 'Y' AND
1375: wdd.locator_id = mil.inventory_location_id AND

Line 1399: mtl_item_locations mil,

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
1403: wdd.released_status = 'Y' AND

Line 1807: mtl_item_locations mil

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
1811: ;

Line 1824: mtl_item_locations mil

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
1828: AND mil.organization_id = pmmtt.organization_id

Line 1917: FROM mtl_item_locations mil,

1913: l_validate_loc_subinventory,
1914: l_validate_loc_empty_flag,
1915: l_loc_disable_date,
1916: l_sub_disable_date
1917: FROM mtl_item_locations mil,
1918: mtl_secondary_inventories msi
1919: WHERE mil.inventory_location_id = p_locator_id
1920: AND msi.secondary_inventory_name = mil.subinventory_code
1921: AND msi.organization_id = mil.organization_id