DBA Data[Home] [Help]

APPS.GMD_ITEM_TECHNICAL_DATA_PUB dependencies on MTL_LOT_NUMBERS

Line 601: FROM mtl_lot_numbers

597:
598:
599: CURSOR check_lot_validity(l_lot_no VARCHAR2, l_lot_orgn_id NUMBER, l_item_id NUMBER) IS
600: SELECT 1
601: FROM mtl_lot_numbers
602: WHERE organization_id = l_lot_orgn_id
603: AND inventory_item_id = l_item_id
604: AND lot_number = l_lot_no;
605: