DBA Data[Home] [Help]

APPS.GMD_ITEM_TECHNICAL_DATA_PUB dependencies on MTL_LOT_NUMBERS

Line 521: FROM mtl_lot_numbers

517:
518:
519: CURSOR check_lot_validity(l_lot_no VARCHAR2, l_lot_orgn_id NUMBER, l_item_id NUMBER) IS
520: SELECT 1
521: FROM mtl_lot_numbers
522: WHERE organization_id = l_lot_orgn_id
523: AND inventory_item_id = l_item_id
524: AND lot_number = l_lot_no;
525: