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_TRANSACTION_LOVS dependencies on MTL_SERIAL_NUMBERS

Line 348: --from mtl_serial_numbers

344: l_from_sub:=p_from_secondary_name;
345: l_from_sub_asset_inventory:=p_from_sub_asset_inventory;
346: --select current_subinventory_code
347: --into l_From_Sub
348: --from mtl_serial_numbers
349: --where current_organization_id = l_org
350: --and serial_number = p_Serial
351: --and inventory_item_id = p_Inventory_Item_Id;
352:

Line 548: from mtl_serial_numbers

544: p_Serial_Number IN VARCHAR2) IS
545: BEGIN
546: OPEN x_RSerials FOR
547: select serial_number,current_subinventory_code,current_locator_id, lot_number
548: from mtl_serial_numbers
549: where Current_Organization_Id = p_Current_Organization_Id
550: AND inventory_item_id = p_Inventory_Item_Id and current_status = 1
551: and serial_number like p_Serial_Number;
552:

Line 566: from mtl_serial_numbers

562: BEGIN
563:
564: OPEN x_RSerials FOR
565: select serial_number,current_subinventory_code, current_locator_id,lot_number
566: from mtl_serial_numbers
567: where Current_Organization_Id = p_Current_Organization_Id
568: and inventory_item_id = p_Inventory_Item_Id and current_status = 4
569: and serial_number like p_serial_number;
570:

Line 603: from mtl_serial_numbers a, mtl_lot_numbers b

599: OPEN x_RSerials FOR
600: SELECT
601: a.serial_number,a.current_Subinventory_code,Nvl(a.current_locator_id,-1),
602: a.lot_number, a.revision ,b.expiration_date
603: from mtl_serial_numbers a, mtl_lot_numbers b
604: where a.Current_organization_Id = p_Current_Organization_Id
605: and a.inventory_item_id = p_Inventory_Item_Id
606: and a.current_status = 3
607: AND a.lot_number = b.lot_number

Line 617: from mtl_serial_numbers a , mtl_lot_numbers b

613: a.current_subinventory_code,
614: Nvl(a.current_locator_id,-1),
615: a.lot_number, a.revision,
616: b.expiration_date
617: from mtl_serial_numbers a , mtl_lot_numbers b
618: where a.Current_organization_Id = p_Current_Organization_Id
619: and a.inventory_item_id = p_Inventory_Item_Id
620: and a.current_status = 3
621: and a.serial_number like p_serial_number