APPS.INV_TRANSACTION_LOVS dependencies on MTL_LOT_NUMBERS

Line 489: FROM mtl_lot_numbers

485: p_Lot IN VARCHAR2) IS
486: BEGIN
487: OPEN x_Lots FOR
488: SELECT Lot_Number,to_char(expiration_date,'MM-DD-YYYY')
489: FROM mtl_lot_numbers
490: WHERE organization_id = p_Organization_Id AND
491: inventory_item_id = p_Inventory_Item_Id AND
492: lot_number like (p_lot);
493:

Line 506: FROM mtl_onhand_quantities_detail a, mtl_lot_numbers b

502: p_Lot IN VARCHAR2) IS
503: BEGIN
504: OPEN x_Lots FOR
505: SELECT b.Lot_Number,to_char(b.expiration_date,'MM-DD-YYYY')
506: FROM mtl_onhand_quantities_detail a, mtl_lot_numbers b
507: -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
508: WHERE a.organization_id = p_Organization_Id AND
509: a.inventory_item_id = p_Inventory_Item_Id AND
510: a.subinventory_code = p_subcode AND

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