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.INV_UI_ITEM_ATT_LOVS dependencies on MTL_LOT_NUMBERS

Line 429: FROM mtl_lot_numbers

425: IF p_shelf_life_code = 1 THEN
426: BEGIN
427: SELECT status_id
428: INTO l_number
429: FROM mtl_lot_numbers
430: WHERE organization_id = p_organization_id
431: AND inventory_item_id = p_inventory_item_id
432: AND lot_number = p_lot_number;
433:

Line 466: FROM mtl_lot_numbers_all_v

462: SELECT expiration_date
463: , NVL(status_code, '')
464: INTO x_expiration_date
465: , x_lot_status
466: FROM mtl_lot_numbers_all_v
467: WHERE organization_id = p_organization_id
468: AND inventory_item_id = p_inventory_item_id
469: AND lot_number = p_lot_number
470: AND ROWNUM < 2

Line 518: FROM mtl_lot_numbers_all_v

514: BEGIN
515: IF l_global_profile = 'Y' THEN
516: SELECT expiration_date
517: INTO x_expiration_date
518: FROM mtl_lot_numbers_all_v
519: WHERE organization_id <> p_organization_id
520: AND inventory_item_id = p_inventory_item_id
521: AND lot_number = p_lot_number
522: AND ROWNUM = 1;

Line 642: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms

638: , inv_project.get_project_id
639: , inv_project.get_project_number
640: , inv_project.get_task_id
641: , inv_project.get_task_number
642: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
643: WHERE a.current_organization_id = p_current_organization_id
644: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)
645: AND a.inventory_item_id = p_inventory_item_id
646: AND (a.group_mark_id IS NULL OR a.group_mark_id = -1)

Line 694: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms

690: , inv_project.get_project_id
691: , inv_project.get_project_number
692: , inv_project.get_task_id
693: , inv_project.get_task_number
694: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
695: WHERE a.current_organization_id = p_current_organization_id
696: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)
697: AND a.inventory_item_id = p_inventory_item_id
698: AND a.current_subinventory_code = p_current_subinventory_code

Line 2343: FROM mtl_lot_numbers

2339: ELSE
2340: BEGIN
2341: SELECT MIN(expiration_date)
2342: INTO x_expiration_date
2343: FROM mtl_lot_numbers
2344: WHERE organization_id = p_organization_id
2345: AND inventory_item_id = p_inventory_item_id
2346: AND lot_number = p_lot_number;
2347:

Line 3459: FROM mtl_lot_numbers

3455: , x_supplier_lot_number
3456: , x_territory_code
3457: , x_vendor_name
3458: , x_description
3459: FROM mtl_lot_numbers
3460: WHERE organization_id = p_org_id
3461: AND inventory_item_id = p_inventory_item_id
3462: AND lot_number = p_lot_number;
3463: EXCEPTION