DBA Data[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: