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 404: FROM mtl_lot_numbers

400: IF p_shelf_life_code = 1 THEN
401: BEGIN
402: SELECT status_id
403: INTO l_number
404: FROM mtl_lot_numbers
405: WHERE organization_id = p_organization_id
406: AND inventory_item_id = p_inventory_item_id
407: AND lot_number = p_lot_number;
408:

Line 437: FROM mtl_lot_numbers_all_v

433: SELECT expiration_date
434: , NVL(status_code, '')
435: INTO x_expiration_date
436: , x_lot_status
437: FROM mtl_lot_numbers_all_v
438: WHERE organization_id = p_organization_id
439: AND inventory_item_id = p_inventory_item_id
440: AND lot_number = p_lot_number
441: AND ROWNUM < 2

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

580: , inv_project.get_project_id
581: , inv_project.get_project_number
582: , inv_project.get_task_id
583: , inv_project.get_task_number
584: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
585: WHERE a.current_organization_id = p_current_organization_id
586: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)
587: AND a.inventory_item_id = p_inventory_item_id
588: AND (a.group_mark_id IS NULL OR a.group_mark_id = -1)

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

632: , inv_project.get_project_id
633: , inv_project.get_project_number
634: , inv_project.get_task_id
635: , inv_project.get_task_number
636: FROM mtl_serial_numbers a, mtl_lot_numbers b, mtl_material_statuses_tl mms
637: WHERE a.current_organization_id = p_current_organization_id
638: AND NVL(a.lpn_id, -1) = NVL(p_lpn_id, -1)
639: AND a.inventory_item_id = p_inventory_item_id
640: AND a.current_subinventory_code = p_current_subinventory_code

Line 2256: FROM mtl_lot_numbers

2252: ELSE
2253: BEGIN
2254: SELECT MIN(expiration_date)
2255: INTO x_expiration_date
2256: FROM mtl_lot_numbers
2257: WHERE organization_id = p_organization_id
2258: AND inventory_item_id = p_inventory_item_id
2259: AND lot_number = p_lot_number;
2260:

Line 3370: FROM mtl_lot_numbers

3366: , x_supplier_lot_number
3367: , x_territory_code
3368: , x_vendor_name
3369: , x_description
3370: FROM mtl_lot_numbers
3371: WHERE organization_id = p_org_id
3372: AND inventory_item_id = p_inventory_item_id
3373: AND lot_number = p_lot_number;
3374: EXCEPTION