APPS.INV_LABEL_PVT13 dependencies on MTL_MATERIAL_STATUSES

Line 103: l_status MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE;

99: l_count NUMBER;
100:
101: l_parent_lot_number VARCHAR2(80);
102: l_grade_code VARCHAR2(150);
103: l_status MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE;
104: l_lot_creation_date VARCHAR2(100);
105: l_lot_expiration_date VARCHAR2(100);
106:
107: l_print_count NUMBER;

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(+);