APPS.INV_LABEL dependencies on MTL_MATERIAL_STATUSES

Line 3985: l_return_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE; -- Bug 13624825;

3981: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
3982: AND nvl(mtlt.lot_number,'@@@@') = nvl(l_lot_number,'@@@@');
3983:
3984: l_return_status_id NUMBER;
3985: l_return_status_code MTL_MATERIAL_STATUSES.STATUS_CODE%TYPE; -- Bug 13624825;
3986: l_organization_id NUMBER;
3987: l_subinventory_code VARCHAR2(30);
3988: l_locator_id NUMBER ;
3989: l_lpn_context NUMBER;

Line 4184: from mtl_material_statuses

4180: END IF;
4181: IF (l_return_status_id IS NOT NULL AND l_return_status_id <>-1) THEN
4182: BEGIN
4183: SELECT status_code into l_return_status_code
4184: from mtl_material_statuses
4185: where status_id = l_return_status_id;
4186: EXCEPTION
4187: WHEN NO_DATA_FOUND THEN
4188: l_return_status_code := NULL;