APPS.INV_LABEL_PVT13 dependencies on MTL_MATERIAL_STATUSES

Line 106: l_status MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE;

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

Line 505: FROM mtl_lot_numbers mln, MTL_MATERIAL_STATUSES mms

501: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.expiration_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) expiration_date,
502: mms.status_code
503: INTO l_parent_lot_number, l_grade_code, l_lot_creation_date,
504: l_lot_expiration_date, l_status
505: FROM mtl_lot_numbers mln, MTL_MATERIAL_STATUSES mms
506: WHERE mln.organization_id = l_batch_table_type(j).org_id AND
507: mln.inventory_item_id = l_batch_table_type(j).item_id AND
508: mln.lot_number = l_batch_table_type(j).lot_number and
509: mln.status_id = mms.status_id(+);

Line 571: FROM mtl_lot_numbers mln, MTL_MATERIAL_STATUSES mms

567: FND_DATE.DATE_TO_DISPLAYDT(dateval=>mln.expiration_date, new_client_tz_code=>FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE,calendar_aware=>l_calendar_aware) expiration_date,
568: mms.status_code
569: INTO l_parent_lot_number, l_grade_code, l_lot_creation_date,
570: l_lot_expiration_date, l_status
571: FROM mtl_lot_numbers mln, MTL_MATERIAL_STATUSES mms
572: WHERE mln.organization_id = l_batch_table_type(j).org_id AND
573: mln.inventory_item_id = l_batch_table_type(j).item_id AND
574: mln.lot_number = l_batch_table_type(j).lot_number and
575: mln.status_id = mms.status_id(+);