[Home] [Help]
APPS.CSP_MO_MTLTXNS_UTIL dependencies on MTL_LOT_NUMBERS
Line 1061: FROM mtl_lot_numbers
1057: l_mtlt_tbl(l_index).primary_quantity := l_csp_mtltxn_rec.primary_quantity;
1058: l_mtlt_tbl(l_index).lot_number := p_lot_number;
1059:
1060: SELECT expiration_date INTO l_mtlt_tbl(l_index).lot_expiration_date
1061: FROM mtl_lot_numbers
1062: WHERE inventory_item_id = l_csp_mtltxn_rec.inventory_item_id
1063: AND organization_id = p_organization_id
1064: AND lot_number = p_lot_number;
1065: