DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on MTL_LOT_NUMBERS

Line 4023: FROM mtl_lot_numbers lots

4019:
4020: CURSOR cur_get_lot_date (p_item_id NUMBER, p_lot_number VARCHAR2)
4021: IS
4022: SELECT lots.expiration_date
4023: FROM mtl_lot_numbers lots
4024: WHERE lots.inventory_item_id = p_item_id
4025: AND lots.lot_number = p_lot_number;
4026:
4027: TYPE l_mo_lines_tbl_typ IS TABLE OF mtl_txn_request_lines%ROWTYPE