APPS.INV_LABEL_PVT13 dependencies on MTL_LOT_NUMBERS

Line 491: FROM mtl_lot_numbers mln, MTL_MATERIAL_STATUSES mms

487: FND_DATE.DATE_TO_DISPLAYDT(mln.expiration_date, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) expiration_date,
488: mms.status_code
489: INTO l_parent_lot_number, l_grade_code, l_lot_creation_date,
490: l_lot_expiration_date, l_status
491: FROM mtl_lot_numbers mln, MTL_MATERIAL_STATUSES mms
492: WHERE mln.organization_id = l_batch_table_type(j).org_id AND
493: mln.inventory_item_id = l_batch_table_type(j).item_id AND
494: mln.lot_number = l_batch_table_type(j).lot_number and
495: mln.status_id = mms.status_id(+);

Line 556: FROM mtl_lot_numbers mln, MTL_MATERIAL_STATUSES mms

552: FND_DATE.DATE_TO_DISPLAYDT(mln.expiration_date, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) expiration_date,
553: mms.status_code
554: INTO l_parent_lot_number, l_grade_code, l_lot_creation_date,
555: l_lot_expiration_date, l_status
556: FROM mtl_lot_numbers mln, MTL_MATERIAL_STATUSES mms
557: WHERE mln.organization_id = l_batch_table_type(j).org_id AND
558: mln.inventory_item_id = l_batch_table_type(j).item_id AND
559: mln.lot_number = l_batch_table_type(j).lot_number and
560: mln.status_id = mms.status_id(+);